Hi,

I have around 7000 outlook messages stored in a folder. (Not in Outlook, saved seperaly in my PC in a folder named "emails"). Extracting data from them is very time consuming and I wonder whether there is a way to create an excel macro to extract the below specified data from outlook messages.

1. All emails data feilds are in same format, only the value of each feild is different.
2. There are over 30 feilds in each email, but I only need data from following 19 feilds.
First name :
Last name :
Email address :
Address :
City :
State :
Zip :
Social security :
Bday month :
Bday day :
Bday year :
Amount :
Home phone :
Mobile phone :
Income monthly :
Phone work :
Next pay date m :
Next pay date d :
Next pay date y :

3. I want to extract all above menioned 19 feilds data in to 19 seperate columns in excel.

4. Messages are named as New Applicant, New Applicant (1), New Applicant (2) so on..

4. An example for email message;

New Application
--------------------------------------------

First name :

Last name :

Email address :

Address :

City :

State :

Zip :

Social security :

Bday month :

Bday day :

Bday year :

Amount :

Home phone :

Mobile phone :

Employer name :

Direct deposit :

Income type :

Income monthly :

Months employed :

Phone work :

Pay frequency :

Employer address :

Next pay date m :

Next pay date d :

Next pay date y :

Own home :

Residence date m :

Residence date d :

Residence date y :

Best time tocall :

Drivers license :

Drivers license st :

Cali agree :

X :

Y :
I really appriciate step by step instructions as I really don't know much about macros/vba. (Only knows to copy/paste already written macros and run)

Thank you all in advance
Gangu