How to create an Outlook form to send data to a database

[Billy Williams]

To whom it may concern:
I work on the Help Desk in a corporate IT department. I have created a
basic Outlook form that people fill out and e-mail to the help desk with
their request. I now want to change the form so that when they send it or
click on a "Submit" button, the collected data goes to a database (Access,
SQL, etc.) I need assistance with this function.

Billy Williams
MCP, MOUS, AASET
(e-mail address removed)

 

[Sue Mosher [MVP-Outlook]]

You would need to write code behind the form (or a COM add-in that interacts with the form) to read the data from the Outlook item and then create new or updated items in the database using standard database access techniques such as ADO. See http://www.outlookcode.com/article.aspx?ID=25 for resources.

FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/com...spx?dg=microsoft.public.outlook.program_forms