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











{October 22, 2007}   Mail Tips – I bet you’ll love this tip :)

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

Advertisements


[…] 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

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

et cetera
%d bloggers like this: