Forum Moderators: phranque

Message Too Old, No Replies

Email data extraction

need to extract date from emails and comile report

         

peter andreas

10:37 am on Jan 19, 2005 (gmt 0)

10+ Year Member



Does anyone know of an email data extraction utility which will sort through a list of emails in a specific outlook folder, extract some info eg email address, namesubject and some of the message body and write them to a text file so I can generate a report?

IOur website has a feedback form and the mails are are sent via rules to inbox folders based in the subject. Its getting too time consuming to copy and paste all the info I need by hand.
Any info appreciated.

Thanks

kalos

6:13 am on Jan 20, 2005 (gmt 0)

10+ Year Member



Sounds like your form output should go into a comma delimited flat file you could import into a spreadsheet (such as Excel). From there you could sort on whatever criteria you need to generate your reports.

TheDoctor

8:17 pm on Jan 23, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You can also import a comma-delimited file (or CSV - comma separated variable - file) into Access and most other databases.

peter andreas

10:28 pm on Jan 23, 2005 (gmt 0)

10+ Year Member



Thanks for the replies.
I have found a nice programme which does most of what I want called message parse (just do a search in google if anyone else is interested) It won't search individual inbox folders though.

I am thinking of sending my form data to a database and also as an email-is this possible ie to perform both an insert into a database and an email send?