Never Forget an Outlook Email Attachment Again...
Simple Macros You Can Use to Remind You to Insert Your Attachment...
I've attached the macro code, so let me know if you need any help adding the macro to your Outlook!
Go to Tools > Macro > Visual Basic Editor > Project1 > Microsoft Office Outlook > ThisOutlookSession > 'Paste the code below in the open dialog box'). Just hit Save and exit out of all open boxes. That's it.....
Try it out.....
CODE STARTS BELOW (Just COPY and PASTE):
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim m As Variant
Dim strBody As String
Dim intIn As Long
Dim intAttachCount As Integer, intStandardAttachCount As Integer
On Error GoTo handleError
'Edit the following line if you have a signature on your email that includes images or other files. Make intStandardAttachCount equal the number of files in your signature.
intStandardAttachCount = 2
strBody = LCase(Item.Body)
intIn = InStr(1, strBody, "original message")
If intIn = 0 Then intIn = Len(strBody)
intIn = InStr(1, Left(strBody, intIn), "attach")
intAttachCount = Item.Attachments.Count
If intIn > 0 And intAttachCount m = MsgBox("It appears that you mean to send an attachment," & vbCrLf & "but there is no attachment to this message." & vbCrLf & vbCrLf & "Do you still want to send?", vbQuestion + vbYesNo + vbMsgBoxSetForeground)
If m = vbNo Then Cancel = True
End If
handleError:
If Err.Number 0 Then
MsgBox "Outlook Attachment Reminder Error: " & Err.Description, vbExclamation, "Outlook Attachment Reminder Error"
End If
End Sub
Published by Y! Eric
Works out of NY office in developing potential advertiser target list and initiates contact with potential AC customers. Researches partner needs and proposes custom Associated Content advertising solutions... View profile
How to Build an Email List for Your BusinessEvery online business should have a good email list that is profitable for them. Of course there are certain tips that you should follow for creating this list and making it pr...- Top Email Clients for WindowsThere are several email clients specifically designed for the PC, some better than others. If you've got a PC and you're looking into a new email client, you may want to consider the list below.
Excite Email - Avoid All the SpamA review of the email provided by Excite.com, compared to the other leading email providers, what you get and what to expect.- Forgive and Forget? Yes and NoEveryone has heard "forgive and forget". But do we really have to forget the wrongs against us in order to forgive our offenders? Not exactly.
- I like to Call it 'The Death of Email Marketing'A First Step to Eliminating Junk Email
- Email Advertising and the Law
- Effectively Using Email for Business Communications, PR and Marketing
- How Not to Choose an Email Handle
- Email Addiction and How to Cure It
- Do You Still Fall for These Email Hoaxes?
- Email Scams: Six Email Messages You Do Not Want to Click
- How to Build an Opt-In Email List




2 Comments
Post a CommentEric,
VBS gives me an error on this line:
If intIn > 1 And intAttachCount m = MsgBox("It appears that you mean to send an attachment," & vbCrLf & "but there is no attachment to this message." & vbCrLf & vbCrLf & "Do you still want to send?", vbQuestion + vbYesNo + vbMsgBo
Let me know what could be wrong.
I had no idea that was possible. Uploading that code right now.