Extract data from emails

[Ed]

Hello,



I use a PHP form for our "Contact Us" page to collect customer information
(name, company name, address, tel, fax, email address, comments, etc..)
which is emailed to me.



I now have approx. 500 emails with customer data in Outlook Express and I
need to transfer that data into an Excel spreadsheet. Would anyone know of
software program that can transfer the data from the emails to ultimately an
Excel spreadsheet? Each row would have individual customer data.



Thank you in advance.



Ed.

 

[HelpExcel.com]

Ed,

You could save that email as a text file, which could then be loaded into
Excel & parsed.

 

[HelpExcel.com]

Ed,

You could save that email as a text file, which could then be loaded into
Excel & parsed.

 

[Ed]

Before your response, I actually copied & pasted the data into Excel.
Following is an example of what the data looks like. However, each row
contains the entire line in one cell. Is there a way to seperate the
headers from the data; assign each header to a column; and assign the data
to it's respective header column? (i.e. Column A = "Date"; B = "From"; C =
"Subject", etc..)

Date: 16 MAY 2009
From (e-mail address removed)
Subject: DISTRIBUTION
Company_Name: XYZ COMPANY
Title: MR.
First_Name: JOHN
Last_Name: SMITH
Position_in_Company: MANAGER
Street_Address_1: PO BOX 1234
Street_Address_2:
City: NEW YORK
State: NY
Zip_Postal_Code: 100115
Country: USA
Telephone: 212-555-1212
Fax: 212-555-1213
Cell_Mobile: 212-555-1214
Email_Address: (e-mail address removed)
Re_Confirm_Email_Address: (e-mail address removed)
Website_Address: XYZ.COM
Countries_you_Sell_to: USA & CANADA
Products_you_currently_sell: CONSUMER GOODS
Companies_you_sell_to: RETAILERS

 

[Ed]

Before your response, I actually copied & pasted the data into Excel.
Following is an example of what the data looks like. However, each row
contains the entire line in one cell. Is there a way to seperate the
headers from the data; assign each header to a column; and assign the data
to it's respective header column? (i.e. Column A = "Date"; B = "From"; C =
"Subject", etc..)

Date: 16 MAY 2009
From (e-mail address removed)
Subject: DISTRIBUTION
Company_Name: XYZ COMPANY
Title: MR.
First_Name: JOHN
Last_Name: SMITH
Position_in_Company: MANAGER
Street_Address_1: PO BOX 1234
Street_Address_2:
City: NEW YORK
State: NY
Zip_Postal_Code: 100115
Country: USA
Telephone: 212-555-1212
Fax: 212-555-1213
Cell_Mobile: 212-555-1214
Email_Address: (e-mail address removed)
Re_Confirm_Email_Address: (e-mail address removed)
Website_Address: XYZ.COM
Countries_you_Sell_to: USA & CANADA
Products_you_currently_sell: CONSUMER GOODS
Companies_you_sell_to: RETAILERS