HOW TO: Not forget attachment or subject line using Outlook macro

Background

Following VBA code will remind you if you are sending an email with empty subject line, or when you forget the attachment. It checks mail body for word "attach" and then confirms if something is really attached. If you attachment is missing, it will pop-up a dialog box.

The setup

1. In your Outlook 2003, invoke Visual Basic Editor, either by pressing Alt+F11, or navigating the menu as "Tools->Macro->Visual Basic Editor"
2. In the Left hand side "Project" panel, make sure entry named "ThisOutlookSession" is highlighted.
3. Copy paste the code given below in the Right hand side Panel.
4. Exit out of VB Editor by either Alt+Q or by navigating the menu item File->Close.

Security

1. Make sure that the security is set to "High" (Tools->Macro->Security)
2. The changes we made will NOT work with High security, so we need to "certify" our code, so that it always works.
3. Invoke "selfcert.exe" from "C:\Program Files\Microsoft Office\OFFICE11\SELFCERT.EXE"
4. In the dialog that pops up, Type your name.
5. Go back to Visual Basic Editor (Alt+F11 from Outlook)
6. Navigate to Tools->Digital Signature.
7. Click "Choose"
8. Select your name, Click "OK"
9. Click "OK" to come out of "Digital Signature" dialog.
10. Exit out of VB Editor (Alt+Q)

Activating the Macro

1. Restart your Outlook
2. When asked about macros, select "Enable Macros"

Test

1. Try sending an email with empty subject to yourself, to test if everything works.
2. Type "attach" or "attached" in email body and send email to yourself without actually attaching any file.

.. finally "The Code"

Please refer to my earlier post here