Friday, February 25, 2005

Never send an email in outlook, without the attachment

How many times have you got an email that says, Oops, you forgot to attach the attachment. Here is a macro that will remedy that. It basically checks your email for the word "attach". If it finds it, then it checks to see if you have an attachment with the email, otherwise, it will prompt you to attach the file. Here are the steps. (1 to 4, show you how to open the VBA script editor; the rest, where to drop the script) 1. Start Outlook 2. Tools | Macros | Security 3. Choose “Medium”, which will prompt you on whether or not you want to run macros (VBA). You may need to restart Outlook at this point in order for that setting to take effect. 4. Tools | Macros | Visual Basic Editor 5. In the Project window (normally on the left of the editor window), goto to the Microsoft Office Outlook Objects tree item. Under this item, you should see the the item "ThisOutlookSession" 6. Double click on the "ThisOutlookSession" item. This should open a code window on the right. 7. The code window will have two drop down bars. 8. Choose Application from the left drop-down bar. and ItemSend from the right drop down bar. 9. Between the lines Private Sub Application_ItemSend(ByVal Item as Object, Cancel as Boolean) and End Sub add the following lines of code. Dim lngres As Long If InStr(1, Item.Subject, "attach") <> 0 Then If Item.Attachments.Count = 0 Then lngres = MsgBox("'Attach' phrase in caption, but no attachments - send anyway?", _ vbYesNo + vbDefaultButton2 + vbQuestion, "Attachment warning") If lngres = vbNo Then Cancel = True End If End If If InStr(1, Item.Body, "attach") <> 0 Then If Item.Attachments.Count = 0 Then lngres = MsgBox("'Attach' phrase in body, but no attachment - send anyway?", _ vbYesNo + vbDefaultButton2 + vbQuestion, "Attachment warning") If lngres = vbNo Then Cancel = True End If End If 10. close the visual basic editor window. 11. test Outlook by sending an email with any word containing attach (attached, attachment, etc), but without attaching anything to the mail. You should get a warning about no attachments being included. (this idea was borrowed from an MSDN blog post that I had seen)

No comments:

Post a Comment

Remember, if you want me to respond to your comment, then you need to use a Google/OpenID account to leave the comment.