Harvest Data from Outlook Form

[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?

 

[Michael Bauer [MVP - Outlook]]

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?mnu=2&pub=6&lang=en&smp=67&cmd=showitem

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: