VBA to extract Outlook Message to Excel

mutts

New member
Local time
Yesterday, 16:41
Joined
Dec 16, 2013
Messages
4

Update - I can't upload for some reason even (no size, etc. issues), sorry
Hi All,
I receive routine confirmation messages with details and want to extract some of the text into Excel.
Can I please have a VBA script that copies the key information (please see sample) and pastes it in a specified workbook (please see sample).
There is a lot more information in the email, but I only need some related info.
I’ve attached two sample files. One of the email, and the other of a workbook where I want the information to be pasted. This is a running record, so the information should be pasted into the next available row.

I am using MS 2007 Excel and Outlook.
Can anyone assist me please?
Thank you.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom