Search This Blog

Showing posts with label MS Office Outlook. Show all posts
Showing posts with label MS Office Outlook. Show all posts

Saturday, March 15, 2008

Writing mails in Microsoft Outlook

Forgot to mention subject, while writing an official mail??????

Don’t worry……… just follow the simple steps mentioned below and see the result.

Here are the below 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", 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 stvSubject As String

stvSubject = Item.Subject

If Len(stvSubject) = 0 Then

Prompt$ = "Subject is not Specified. 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 prompt you each time u send a mail without the Subject…