Search

Loading...

Tuesday, December 16, 2008

Empty Email Subject Reminder for Microsoft Outlook Office Mails

Do you often forget writing subject for the mails and feel bad later or sent a mail to your boss without subject and was in a embarrassing situation then this mail is for you

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

Here are the steps: -
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 as shown in the below picture


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 you try to send a mail without subject, a pop-up is raised to remind you of the blank subject as show in below PIC

if you know any more similar useful scripts do share with us...


4 comments:

Anonymous said...

Hi,

This is working very good.

Thanks and keep these postings forever

Anonymous said...

nice script!

foodieclaire said...

thanks a lot for this - just came in very very handy...

deepz said...

Thanks

However, this is working only for current session. Once if i close the outlook and reopen, the code does not seem to be working.

Any input?

Post a Comment

Other Interesting Articles



Related Article Widget by ceveni

Search Powered by Google