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

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

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

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/comm...rogram_f orms

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Billy Williams" wrote in message ...
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