This Outlook macro will remind you to attach a file if it finds the word "attach" or "PFA" in your email and no actual file is attached.
Adding a macro to Outlook is easy. Just copy everything below starting with "Private Sub" through "End Sub."
In Outlook, select the "Tools | Macro | Visual Basic Editor" menu option.
In Outlook 2010, Select File | Options | Customize Ribbon | Under Customize the Ribbon | Check the "Developer" option to enable it and click "OK" to close the dialogue box. Then Click on the Developer in the Ribbon Menu and click on Macro.
You may need to expand the project by clicking the plus signs under Project1 until you see ThisOutlookSession, and double-click it. Click into the big white empty page and hit Paste.
Please find the screenshot attached of what the editor should look like below the code.
Click Save and you'll be all set. If you've previously disabled macros you'll need to enable them.
*Note: Outlook Express doesn't support macros.
*Update: Outlook counts files used in Signatures as attachments. If your signature uses one or more files, find the line intStandardAttachCount = 0 and make it equal the number of files in your signature.
Code Begins:
--------------------------------------------------------------------------------------------------------------------
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim m As Variant
Dim strBody As String
Dim intIn, intPFA 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 = 0
strBody = LCase(Item.Body)
intIn = InStr(1, strBody, "original message")
If intIn = 0 Then intIn = Len(strBody)
intPFA = intIn
intIn = InStr(1, Left(strBody, intIn), "attach")
intPFA = InStr(1, Left(strBody, intPFA), "pfa")
intAttachCount = Item.Attachments.Count
If (intIn > 0 Or intPFA > 0) And intAttachCount <= intStandardAttachCount Then
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
--------------------------------------------------------------------------------------------------------------------
Code Ends.
| Outlook Macro Editor |
Courtesy: This blog was enhanced from this original site Markbird site
Comments
Post a Comment