Outlook rule to run VBA script to pass the body of email to external program

email vba shell outlook rule
dshin picture dshin · May 10, 2010 · Viewed 7.8k times · Source

I've set up an Outlook rule that filters emails. I want to run an external program (python script) to parse each such email.

I know of the SHELL function, but I need a way to pass the body of the email to my external program.

Answer

wonderfulthunk picture wonderfulthunk · May 10, 2010

Google is your friend for this one, I got this snippet by searching "outlook vba script".

Basically for the body of the email you want to pass Item.Body to your python script.

http://support.microsoft.com/kb/306108

Sub CustomMailMessageRule(Item As Outlook.MailItem)
    MsgBox "Mail message arrived: " & Item.Subject
End Sub`

Sub CustomMeetingRequestRule(Item As Outlook.MeetingItem)
    MsgBox "Meeting request arrived: " & Item.Subject
End Sub

Related questions

Sending email attachments from Excel via VBA

I've written a macro that at the click of a button it sends an automated email via Outlook. Everything runs smoothly except I just can't figure out how to attach a file to the email. Everywhere I've looked, example code …

Read More
How can I set "High Importance" on email sent using VBA?

I tried setting a few properties on this object to send an email with high importance, but nothing seemed to work. Here is what I tried: objEmail.Importance = 2 objEmail.Configuration.Fields.Item("urn:schemas:mailheader:X-MSMail-Priority") = "High" ' For Outlook 2003 …

Read More
Add CC and BCC with Mail Merge

I am trying to add the cc function to a mail merge. In other words, I not only need to personalize the emails to different email addresses. I would also like each email to be include a CC that shows …

Read More