Magnificent Magical Mumbai

This is a concern for all of us. A mail with a blank subject line brings a bad impression. One of my earlier posts mentioned about Self Destructing mails, but what do you do if you only forgot the subject line.

Just follow the below steps and you’ll never ever forget to put the subject.

Note: This only works if you are using Outlook.

• Open your outlook
• Open the Visual Basic editor by press Alt+F11
• On the Left Pane, you will see “Microsoft Outlook Objects” or “Project1″, expand this. Now you will see the “ThisOutLookSession”
• Double click on “ThisOutLookSession”. It will open up a code pane
• Copy and Paste the following code in the right pane




Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)

Dim strSubject As String

strSubject = Item.Subject

If Len(Trim(strSubject)) = 0 Then

Prompt$ = “Subject is Empty. Are you sure you want to send the Mail?”

If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, “Check for Subject”) = vbNo Then

Cancel = True

End If

End If

End Sub

• Save this and now close the VB Code editor and take a breath

Going forward, this macro will make sure you do not make the mistake of sending a mail without a subject.