Automate Data Collection Using E-Mails in Access 2007

A new feature in Access 2007 is the Collect Data Through E-mail Messages Wizard, which works with Outlook 2007 to generate and send an e-mail message that includes a data entry form. When recipients fill out and return a form, the replies are processed according to your specifications. For example, if you choose to have the replies automatically processed, the contents of the form are added to the appropriate table in your database as soon as the reply hits your Outlook In-box. This article on Office Online shows you how to use the Wizard: Collect data by using e-mail messages.

A post on the Access Team Blog today runs through advanced use of the data collection feature to automate data collection forms using VBA.

Collect Data for an Access 2007 Database Using Outlook Emails

TechRepublic.com Office blogger, Mary Ann Richardson, has posted a very useful article on how to use the new Access 2007 Collect Data Through Outlook E-mail feature to automatically log data submitted by email direclty into an Access 2007 table.

How To Export E-mail Messages to Access using VBA

From TechRepublic.Com blogger, Susan Harkins.

Exporting Outlook folders and their contents is a common and simple enough task most of the time using the Import And Export Wizard. But you can’t append records to an existing file using the Wizard. If you want to export frequently to the same database, or if you just want to take the process out of user hands, use VBA to automate the export. Article and Code