Now Never miss to mention the subject in the mail

It happens many time that you write a mail but forgot to mention the subject. I know it is embarrassing to send an important official mail without a subject. It has happened to me also when I used to do it a lot and I remember my Manager making strange faces at me.

Well that was past, I realized that a mail without a subject brings a bad impression on others. After learning VBA I wondered whether it is possible to add some extra functionality in the outlook to alert us whenever we miss to mention the subject and I was able to write a very simple macro to achieve this extra feature which doesn't come with Microsoft Office Outlook.

Steps to write and store this Macro

1. Open your Outlook.

2. Press Alt+F11. This opens the Visual Basic Editor and then Press Ctrl+R which in turn open Project-Project 1 (left side)

3. On the Left Pane, one can see "Microsoft Outlook Objects" or "Project1", expand this. Now one can see the "ThisOutLookSession".

4. Double click on "ThisOutLookSession". It will open up a Code Pane on the right hand side.

5. Copy and Paste the following code in the right pane (Code Pane) and save it

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

6. Now whenever u try to send a mail without subject, a pop-up is raised to remind you of the blank subject.

See how simple it is to use VBA to add these extra features!! If you like this post then why don't you subscribe to our mailing list to get such tricks right in your mailbox.

Have a nice day!