Run VBA code on receipt of e-mail

[White Horse]

Can the receipt of an e-mail run a macro, and if so, could someone post
sample code?

 

[Sue Mosher [MVP-Outlook]]

One of the easiest ways is to use a "run a script" rule in Rules Wizard to run a VBA procedure with a MailItem or MeetingItem as its parameter. That item is processed by the code:


Sub RunAScriptRuleRoutine(MyMail As MailItem)
Dim strID As String
Dim olNS As Outlook.NameSpace
Dim msg As Outlook.MailItem

strID = MyMail.EntryID
Set olNS = Application.GetNamespace("MAPI")
Set msg = olNS.GetItemFromID(strID)
' do stuff with msg, e.g.
MsgBox msg.SUbject

Set msg = Nothing
Set olNS = Nothing
End Sub

See http://www.outlookcode.com/d/code/zaphtml.htm#ol2002 for another example.


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[White Horse]

Thanks Sue! Your tip solved my problem. I'm posting a new help
request for printing image attachments. Hope I hear from you on this
one.

Mike