Data Collection Responses
In the last post, we talked about sending out data collection emails. In this post, we'll talk about what happens to those mails when they come back and how the data gets moved from Outlook back in to the Access database.
Responding to the Mail
The data collection email can either be a very simple HTML form (with no controls, so it isn't blocked by any firewalls or gateways) or can be a rich InfoPath form. In either case, the person getting the emailed form simply replies to the email message to submit data. An InfoPath form might look something like this:

(Click image to enlarge)
When the user responds to an InfoPath form, she can hit the Submit button and the form will be automatically routed to the person who started the data collection, so even if the email was forwarded it will go back to the right place. For HTML forms, she simply hits Reply, completes the form, and hits Send.

(Click image to enlarge)
Automatic Processing
In the wizard, you can choose to have the replies automatically processed, in which case, you needn't do anything to push the data from Outlook to Access. The next time you open Outlook any new replies will be automatically added to the Access database. You'll be able to see the replies in your Inbox, in a special folder called "Access Data Collection Replies":

In addition, you can view the status of replies (for either automatic or manual replies) from the ribbon by clicking the Manage Replies button:

(Click image to enlarge)
This launches a dialog that lets you view status, resend messages, and so on:

(Click image to enlarge)
Manually Processing Replies
You can also elect to manually process the replies when setting up the data collection. If you do this, you'll need to go to your inbox, and use the context menu in the Access Data Collection Replies folder to "Export data to Microsoft Office Access".

(Click image to enlarge)
You'll get a confirmation dialog to make sure that you've got the right messages, and will let you see the data that will be added to the database:

Next Time
The next post will cover building customized ribbons in Access using VBA.