Add to rule macro that exports Body, date/time sent, and sender into excel spreadsheet.

[vamosj]

I have a rule setup to move emails based on subject line. What I am attempting to do is when this rule is triggered, it also grabs the Body, Sent Date, and Sender and places it into an Excel Spreadsheet. After doing a bit of research I have come up with the following and the issue i'm having is getting the Msg Object set properly so I can pull the data from the email. Anyone able to assist?

So far I have come up with the following. Trying to have this happen when a rule activates. Will continue to work on this if anyone has any ideas that will help me out. Right now the main issue is getting Msg identified.

Please Login or Register  to view this content.

Xpost here

[vamosj]

**** Adding to OP to make this a little easier to read ***

[vamosj]

And figured out the issue. Code is posted below for anyone else in the future who may want to do the same thing. The problem I had was sine I was trying to troubleshoot it without it being triggered by a rule there was no MailItem attached to a specific email. When it was triggered I no longer needed to set the "Msg" object as "MyMail" was now linked with the incoming email that triggered the rule.

Please Login or Register  to view this content.