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

I have no idea.

-----Original 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
.

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

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!

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!

Tabitha,

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

Tim.
saxifrax at pacbell dot net



"Tabitha Lallone" < wrote in message
...


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!