Forgot to mention subject line on an official mail??? We can avoid it.

If you want to avoid sending official mails with out a subject please perform the following steps:

1. Open your outlook

2. Press Alt+F11. This opens the Visual Basic editor

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.

5. Copy and Paste the following code in the right pane. (Code 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

=============================================================================================

6. Save this and now close the VB Code editor.

From now on, this macro will make sure you do not make the mistake of sending a mail without a subject line

Cheers
Rahul
Arora

 

What did you think of this article?




Trackbacks
  • Trackbacks are closed for this post.
Comments

  • Friday, December 28. 2007 melwyn wrote:
    helpful
    Reply to this
  • Thursday, February 14. 2008 Manjunath wrote:
    HI,

    The information you had provided is good, but it is not applicable always
    ie on my PC its working fine but on my friends system its not.
    Let me brief it : Immediately after saving the script if we try to send without a subject line it gives the pop-up message, but after restarting the PC it does not work. Can u help me on this.
    Reply to this
    1. Tuesday, February 26. 2008 Ismail wrote:
      hi manju,

      I have send a mail regarding the step you need to carry out please check it out and let me know the status
      Reply to this
Leave a comment

Submitted comments are subject to moderation before being displayed.

 Name (required)

 Email (will not be published) (required)

Your comment is 0 characters limited to 3000 characters.