Home > Office Hack, Tutorial, Windows > Office Hack Series 1 : Forgot to mention subject in Outlook mail???

Office Hack Series 1 : Forgot to mention subject in Outlook mail???

September 22, 2010 Leave a comment Go to comments

Scenario : You use Microsoft Outlook for your official correspondence. But you keep forgetting to add Subject to your mails. How do you overcome that ??

Solution : Yes…. It’s a concern for all. A mail without a subject creates a bad impression and makes us appear Unprofessional. So how do you avoid this.

To avoid this, just follow the simple steps mentioned below : –

1. Open your Outlook.
2. Press Alt+F11. This opens the Visual Basic Editor and open Project-Project 1 (left side). If this doesn’t open Project-Project 1 then press then Press Ctrl+R.
3. On the Left Pane, you can see “Microsoft Outlook Objects” or “Project1”, expand this. Now you 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
For the technologically challenged……what this step does is adds the above code to outlook as Macro.
6. Now whenever you try to send a mail without subject, a pop-up is raised to remind you of the blank subject.

Note : This issue has been addressed in Office 2010 but works for previous versions.
Hope this helps…..till then….Stay Sharp….
  1. Grantz
    October 21, 2010 at 2:36 pm

    this was brilliant thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: