KE SARA, SARA, what ever will be, will be …











To ensure that the e-mail is having Subject, follow below steps and make a macro to prevent sending mails without subject:

Few Simple Steps

1. Open your outlook

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

3. On the Left Pane, one can see “Microsoft Outlook Objects”, expand this. Now one can see the “ThisOutLookSession”.

4. Click on “ThisOutLookSession”.

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(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


Save this and now close the VB Code editor and take a breath. From now on, this macro will make sure you do not make the mistake of sending a mail without subject.

Now isn’t it really easy!!! Enjoy



[...] You can read the rest of this blog post by going to the original source, here [...]



[...] Check it out! While looking through the blogosphere we stumbled on an interesting post today.Here’s a quick excerptTo ensure that the e-mail is having Subject, follow below steps and make a macro to prevent sending mails without subject : Few Simple Steps 1. Open your outlook 2. Press Alt+F11. This open the Visual Basic editor 3. On the Left Pane, one can see “Microsoft Outlook Objects”, expand this. Now one can see the “ThisOutLookSession”. 4. Click on “ThisOutLookSession”. 5. Copy and Paste the following code in the right pane.(Code Pane) Private Sub Application_ItemSend [...]



Leave a Reply

et cetera