Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export outlook mail message to excel
Best method is up to you. The task can be fully automated with a macro. I
could write the macro if I knew the folder name in outlook you are using. The macro will go into each item in the outlook folder open the item and import the the data into a workbook. the macro can be writen either using VBA in outlook or excel. It would probably easier if you had the macro in outlook since you probably always have outlook opened. Doing a macro from excel would mean opening up a workbook an running the macro. You could even have an event in outlook that would automatically perform the exporting. "!ngeniuos" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export from 07 excel to outlook contacts | Excel Worksheet Functions | |||
how do i export from excel to outlook | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel(with hyperlinks) as a message body of outlook mail | Excel Discussion (Misc queries) | |||
export from Outlook to Excel | Setting up and Configuration of Excel |