View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
!ngeniuos !ngeniuos is offline
external usenet poster
 
Posts: 1
Default Export outlook mail message to excel

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

tel=0123456789
Region=NorthC
fax=
Company Name=Company Ltd
Position=Marketing assistant
Address=106 Press Ave
Canberra
Postal code=
MSoutlook=1
WinXP=1

--
!ngeniuos
(99% Perspiration)