Access provides great tools for organizing, searching and analyzing data. But before you can use those great tools, you must first enter the data. In Access 2007, a wizard with the monster-name, “Collect Data Through Email Messages Wizard,” for collecting information by email was introduced. Two aspects of this process make it particularly attractive:
1) You can set the wizard to automatically deliver data from the email replies directly into the appropriate fields of your database, and
2) The data is being entered by the primary source of the information – from their keyboard to your table.
This wizard lives – as you might guess – on the External Data tab of the Ribbon in the Collect Data group. You can start the wizard by first selecting a table or query that holds the fields you want to send out and then clicking the Create E-mail icon.