Wednesday, February 15, 2012

How not to forget subject in outlook

It’s very common sometimes we forget to add subject line while sending the emails. But it not leaves a good impression when you are sending official emails to important people.

To avoid this, just follow the simple steps mentioned below and see the result -

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.

Put below code in this window
 
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. Save the file.
Now whenever u tries to send a mail without subject, it will raise a pop-up to remind you

No comments:

Post a Comment