How to Collect Data Email in Access 2007

Using the Microsoft Office Access 2007 software you may send out a form to multiple users to collect data. When you are connected to a server, it may be helpful to update information by collecting the data through emails. A common scenario might involve emailing a new employee to gather contact information to add to the employee information database. You may also have the data sent back automatically after a user fills it out.

Instructions

1. Open the Microsoft Access 2007 database on your computer.

2. Click on the "Supporting Objects" option from the left side of the application. Right-click on the "Employees" option.

3. Click on the "Collect and update data via email" option. Click on the "HTML form" option and then click on the "Next" button.

4. Select the fields for the date you want to collect from the "Fields in table" list and then click on the "Next" button.

5. Click on the box next to the "Automatically process replies" field so that it's selected if you want the data to be sent back to you automatically. Click on the "Next" button.

6. Enter the name for the people you want to collect data from into the "To" field. Enter a message into the body of the email and then click on the "Send" button.

References

• Database Dev: Collect Data by Using Email Messages in Microsoft Access 2007
• Microsoft Office: Collect data in Access 2007 by Using Email
• Inform IT: Appending an Access 2007 Form Using Email