- Community Pick
- Experts Exchange Approved
Background. Unfortunately, Outlook does not enforce the use of the subject line or even offer an option for reminding you when you’ve forgotten to enter one. From Outlook's perspective the subject is optional.
Solution. Happily there’s a simple solution to this issue. Through the use of a few lines of VBA (Visual Basic for Applications) code we can have Outlook check the subject line of every item we send. If the subject line is blank, then the code can cancel the send and display a message asking us to give the item a subject. Once the subject is filled in Outlook allows the item to go on its way.
Requirements. This solution will work with any version of Outlook from 2000 through 2007. Outlook 2010 adds a built-in check for a blank subject line (Note: Thanks to bromy2004 for pointing that out to me). The solution does not work with Outlook Web Access (OWA). OWA is Outlook in name only. Unlike the full version of Outlook, OWA is a server-side process that runs at the Exchange server. OWA does not support the use of VBA.
Instructions. Follow these instructions to use this solution.
- 1
Add the Code to Outlook
Outlook 2000 - 2003.
1. Start Outlook.
2. Click Tools > Macro > Visual Basic Editor.
3. If not already expanded, expand Microsoft Office Outlook Objects and click on ThisOutlookSession.
4. Copy the code below and paste it into the right-hand pane of Outlook's VB Editor window.
5. Edit the code as needed. I included comment lines wherever something needs to or can change.
6. Click the diskette icon on the toolbar to save the changes.
7. Close the VB Editor.
8. Click Tools > Macro > Security.
9. Set the "Security Level" to Medium.
10. Close Outlook
11. Start Outlook
12. Outlook will display a dialog-box warning that ThisOutlookSession contains macros and asking if you want to allow them to run. Click Yes.
Outlook 2007.
1. Start Outlook.
2. Click Tools > Macro > Visual Basic Editor.
3. If not already expanded, expand Microsoft Office Outlook Objects and click on ThisOutlookSession.
4. Copy the code below and paste it into the right-hand pane of Outlook's VB Editor window.
5. Edit the code as needed. I included comment lines wherever something needs to or can change.
6. Click the diskette icon on the toolbar to save the changes.
7. Close the VB Editor.
8. Click Tools > Trust Center.
9. Click Macro Security.
10. Set "Macro Security" to Warnings for all macros.
11. Click OK.
12. Close Outlook
13. Start Outlook. Outlook will display a dialog-box warning that ThisOutlookSession contains macros and asking if you want to allow them to run. Click Yes..
- 2
Test the Solution
Create a test message and leave the subject blank. Click Send. Outlook should cancel the send and display a pop-up message that looks something like this.
Links to Other BlueDevilFan Articles
1. Creating Linked Notes in Outlook 2007
2. Extending Outlook Rules via Scripting
3. Importing and Exporting Outlook 2007 Categories
4. Outlook 2007 Corporate Categories System
5. Automatically Printing/Saving Emails/Attachments in Outlook
6. Never Again Forget to Add that Attachment to your Outlook Email
7. Enhancing Outlook 2007 Meeting Reminders
by: younghv on 2010-04-24 at 13:49:12ID: 13749
Thank you for putting this together - "Yes" vote above.