ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Extract data from emails (https://www.excelbanter.com/excel-worksheet-functions/231108-extract-data-emails.html)

Ed[_4_]

Extract data from emails
 
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[_2_]

Extract data from emails
 
Ed,

You could save that email as a text file, which could then be loaded into
Excel & parsed.
--
Regards,
Eddie
http://www.HelpExcel.com


"Ed" wrote:

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.







All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com