Macro to export from Outlook message body and append to an existing Excel spreadsheet

[Alain]

I get several outlook email messages like this per day. The labels are always the same (I.e. Date of change, Change initiated by, etc). Our existing process is to cut and paste this info into excel. I am Pretty proficient at excel, but not VBA. How can I automate getting the info out of the outlook email message and into an Excel spreadsheet?

Subject: Profiler modification: Client Computing Services

Date of change: 2013-12-16 02:25:17 PM
Change initiated by: Robert Silverman
Directorate: Client Computing Services
Division : Deskside IT Support
Position: 30051253
Modification type: Maintenance of personnel or hierarchical information.
Comments: To update outdated information.

 

[SirJB7]

Hi, Alain!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider starting here:
http://www.rondebruin.nl/win/section1.htm
and trying to find out any method/procedure/code that may lead you to accomplish your job; it's just to know the involved objects and how to handle it properties and methods.

Regards!