Exporting email body to excel

[PeeDee78]

Good morning all

I've done both a forum and google search that have provided me with some examples but as of yet, nothing I seem to be able to adapt to my specific needs.

I'm trying to create a macro that will copy and paste the text from the body of an email into Excel.

I have uploaded a copy of the example email.

The email subject is always from the same address (AMI <[email protected]>) with the same subject header (Metering Emergency Callout - Metering ECO Tracker). I get about 300 per day

Currently I have a rule set up that all these emails move to a new subfolder called AMI Added. Once moved I would like the data to be exported into Excel, one row per email.

I'm still trying to find an example of the best way to do this, and would love to hear some advise from people who use something similar.

Thanks in advance
Kind regards
Paul

[Sean Thomas]

Hi PeeDee,
I dont think its possible to use excel to import data from e-mail.
However i think you can use vba in outlook to export data to excel.

Heres a link that might help

http://www.ozgrid.com/forum/showthread.php?t=14953