Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default 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.




  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help in extract of data Ms. Latte Excel Discussion (Misc queries) 2 August 8th 08 05:27 AM
Tying to extract all data from a pivot pulling from external data Ted Urban Excel Discussion (Misc queries) 3 September 14th 07 10:50 AM
data extract Mona Excel Worksheet Functions 7 May 10th 06 05:17 PM
How to extract the data Shiva Excel Worksheet Functions 2 November 1st 05 04:41 AM
Extract Data Tucson Guy Excel Discussion (Misc queries) 5 December 15th 04 09:41 PM


All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"