Re: Sent custom form responses to database?

Sure, you can send the data anywhere you want, as long as you know how to
write the code for it. Generally for database work, you'll use ADO. See
http://www.outlookcode.com/d/database.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dave" <Dave@discussions.microsoft.com> wrote in message
news:42B2BD07-33AA-44B4-9249-A7333007C083@microsoft.com...
> Hi,
>
> I created a custom Outlook 2002 form for users to complete a survey. I
> then
> have vbscript behind a CommandButton to grab and email me the textbox,
> checkbox, etc. values by creating a string with each question's response
> delimited by a ";"
>
>
> Sample response I get:
> -------------------------
> Joe Smith; ABC Corp;some text...;some more
> text...;True;False;False;True;True;True;etc;etc;
>
> When I get this in my inbox, I paste the responses manually into a Excel
> spreadsheet and use the Text to Column option. BUT is there some cool way
> to
> parse this string and insert/update the responses to an Access or
> SQL database automatically?
>
> Thanks, Dave.