Creating a Macro that will Import Forms from Outlook

  • Thread starter Thread starter Tabby Lallone
  • Start date Start date
T

Tabby Lallone

I'm looking to create a Macro that will pull internet-
submitted forms out of Outlook (i have a backlog of about
4000) into an Excel workbook. It would hopefully deposit
the information in pre-defined columns. Any ideas how to
go about doing this?

Thank you,
tabby
 
How are the forms formatted? Are they web forms submitted with a
"mailto:" action?

If so, you'll need some code to read each one from Outlook and parse
out the contents. If they're all fixed format then that would be
fairly straightforward. You could also try a straight copy/paste of
the contents into XL and see how it looks. Then extract the fields to
a worksheet as a table.

Post an example (or pseudo-example) of one of the forms.


Tim.
 
Hi Tim...the forms look pretty standard. A table with two columns...
one column has the titles, like Name, Account Number, Address, Request.
The second column has the user-specific information, like Jane Doe,
153159, 1534 Merry Lane, New Membership Card.

i.e.

Multiple Subscriber Information Request
SCN
Name
Request
Account Number
Title
Last Name
First Name
Address
City
State
Zip
Zip4
Subscription Start
Subscription End
Monthly
Service Level
Make
Model
Vehicle Year
VIN
 
Tabitha,

If you forward one of the mails to me then I'll take a look.

Tim.
saxifrax at pacbell dot net
 
Back
Top