I am the new guy at work and have been given the tasks of transferring over 4000 outlook emails given to me in a folder that are out of office subject lines. They want me to transfer each Email to an Excel spreadsheet With the from email address and person's name and company off the Email address. I also need the persons Email Address it was sent to, the Out Of Office Reason, and Person to contact with their Email Address and date they will be back which goes in the Reason column.
These are the columns in the spread sheet.


Original name Company Original Email Reason New Name Phone number New Email


Here is a sample Email:


TO Debbie Lewis <dlewis@manco.com


Subject:re:Out of office


-----Original Message-----
From: Debbie Lewis [mailto:dlewis@manco.com]
Sent: Friday, September 04, 2009 12:41 PM
To: Lindsey Lischka
Subject: Out of Office AutoReply:

I am currently out of the office and will return on Monday September 7th after 10:00am. Please contact Jo Anne Moody at jmoody@manco.com if you need immediate assistance.


Each email comes from a different company and not two are alike. Do I use filters or a macro. I'm going nuts typing this stuff all day. Please help