Harvest Data from Outlook Form
 

I want to create an Outlook form to send out as a survey about our cafe.
That's not a problem. My issue is with creating it in such a way that when a
user emails me back their inputs, the results go into a database (access
probably). How can I do such a thing?

Harvest Data from Outlook Form
 

You might start with the ItemAdd event of the Inbox; see the VBA help for an
example.

There read the item's properties, connect to your database, and use the
proper SQL statements to insert the data into a table.

This sample demonstrates how to connect to an Access database by using
ADODB:
http://www.vboffice.net/sample.html?...cmd=showite m

Depending on what you want to do, you might use the Connection.Execute
method with the Insert SQL statement; or use a recordset that looks for
existing data first, then update or insert your data. All that stuff can be
found by looking for ADO and SQL.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Mon, 15 Jun 2009 11:53:01 -0700 schrieb Luke:

I want to create an Outlook form to send out as a survey about our cafe.
That's not a problem. My issue is with creating it in such a way that when
a
user emails me back their inputs, the results go into a database (access
probably). How can I do such a thing?