Creating a Macro that will Import Forms from Outlook
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.
"Tabby Lallone" wrote in message
...
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
|