Creating a Macro that will Import Forms from Outlook

[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

 

[Red Dawg]

I have no idea.

 

[Tim Williams]

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.

 

[Tabitha Lallone]

Forgot to mention that they are submitted via the web "mailto:"
function.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tabitha Lallone]

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tim Williams]

Tabitha,

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

Tim.
saxifrax at pacbell dot net