Export Mail messages content to Excel

[!ngeniuos]

Hi all

I have a web form where users fill in certain info that I request.
However, the responses are overwhelming as now I need a speedy way of
harvesting and sorting responses:-
The send function will email the text result of the form, it gets delivered
and sorted in a folder - in outlook- , and content would look like as below.
What would be the easiest / best method of converting these emails into an
Excel DB with row headers like:- Name; email; tel; address; etc

Content example:-
name=Peter
[email protected]
tel=0123456789
Region=NorthC
fax=
Company Name=Company Ltd
Position=Marketing assistant
Address=106 Press Ave
Canberra
Postal code=
MSoutlook=1
WinXP=1

 

[Roady [MVP]]

You could do something with VBA that goes through all the emails and for
each email it captures the body text, strips the line brakes and field names
and replaces it with a separation character such as a comma or a pipe line
( | ) and dump that single line into a text document.

Then in Excel you could import that text-file as a csv document and specify
your separation character.