Default VBA code for extracting data from email (Outlook) to Excel?

Status
Not open for further replies.

zee123

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,

I regularly receive emails which I need to transfer from outlook to a list on Excel. Can I automate this process? The emails are in this form:

IN 31DEC14
FOR:
FROM:
TYPE:
TEL:
ADRS:
CROSS STREET 2:
POLE #:
MSG:

I would like to copy the data after "IN, TYPE, ADRS, MSG" on different columns in Excel. I am a complete beginner and I don't know which resources to use to achieve this. Can someone please guide me, it will be much appreciated. Thank you.
 
Status
Not open for further replies.
Top