How to Collect Data Via Outook in Access 2007

With the Microsoft Office Access 2007 application you can manage data for users belonging to a server with a specific database file. You can use the email message wizard within Access 2007 to send a message to various users that collects data you need to compile for the database, such as email addresses or phone numbers. The email message wizard also uses Microsoft Outlook 2007 to send the message to users.

Instructions

1. Open the Microsoft Access 2007 application on your computer and then click the "Microsoft Office" button from the top left corner of the program.

2. Click the "Open" option and then select the database file you want to send data from. Click the "Open" button.

3. Select the table containing your data from the navigation pane and then right-click on the table. Click the "Collect and Update Data via Email" option.

4. Click the "Next" button from the wizard dialog box that appears, and then select the "HTML form" option. Click the "Next" button.

5. Click the "Collect new information" option and then click the "Next" button. Select the forms fields you want to be used for collecting data from users. For example, if you want to collect email addresses then you can select the "Email Address" option.

6. Click the "Next" button and then click the box next to the "Automatically process replies and add data" field so that it's selected. Click the "Next" button.

7. Click the "Use the email addresses stored in a field in the database" or "Enter the email addresses in Microsoft Office Outlook" option. Click the "Next" button twice.

8. Enter the message that you want to appear to the recipients and then click the "Next" button twice. Click the "Send" button and you will then receive replies containing the data you requested.

References

• Microsoft Office: Collect Data by Using Email Messages
• Microsoft Office: Data Collection Email Options