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: 25.505  | #66
◀ Previous sample Next sample ▶
SAM SAM
SAM automatically sets the sending account, or sender address, and folder for sent items based on several criteria.

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
ReplyAll ReplyAll
ReplyAll alerts you before unintentionally replying all, or if you are a confidential BCC recipient of the e-mail.
email  Send a message