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

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.
 
Top