Windows only: Microsoft Outlook is a powerful tool —and with a little macro goodness, it will remind you to attach a subject line to your TPS Reports.
Adding the new macro requires a number of steps, but when you are finished you'll have a reminder to add in a subject line—just like Gmail has by default. You'll need to open up the Visual Basic macro editor, find ThisOutlookSession over in the left-hand treeview, and then paste in the macro into the editor.
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) DimstrSubjectAsString strSubject=Item.Subject IfLen(Trim(strSubject))=0Then Prompt$="SubjectisEmpty.AreyousureyouwanttosendtheMail?" IfMsgBox(Prompt$,vbYesNo+vbQuestion+_ vbMsgBoxSetForeground,"CheckforSubject")=vbNoThen Cancel=True EndIf EndIf End Sub
Once you've saved and closed the macro editor, you should receive a warning anytime you forget the subject line—a very useful trick to avoid sending an unfinished email.
Hit the link for the detailed walk-through screenshot tour. Note: this macro was found on at least half a dozen web sites, so we're not really sure who the original author is, but the CodeProject link explains the process in the most user-friendly way. For more, check out how to defer sending emails to avoid embarrassment, or take a look through our top 10 Outlook boosters.
Blank Subject Warning for Outlook 2007 [CodeProject]