VBOffice

Prompt for Missing Subject Before Sending

Another sample for how to check for certain properties before sending an email.

Last modified: 2008/06/19 | Accessed: 26.011  | #66
◀ Previous sample Next sample ▶
Reporter Reporter
VBOffice Reporter is an easy to use tool for data analysis and reporting in Outlook. A single click, for instance, allows you to see the number of hours planned for meetings the next month.

Do you sometimes forget to give your e-mails a subject? You may put this code into the module ThisOutlookSession and get a prompt if the subject is missing.


tip  How to add macros to Outlook
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
  If Trim(Item.Subject) = "" Then
    Cancel = True
    MsgBox "The subject is missing", vbInformation
  End If
End Sub
OLKeeper OLKeeper
OLKeeper reliably prevents users from closing their Outlook window and thus possibly missing reminders or e-mails.
email  Send a message