How to Send Access 2007 Data via Email
Microsoft Access is a powerful database application that offers the ability to input and organize data into related tables that can be cross-referenced in order to keep track of different types of data. Many users can contribute to an Access database. One way to collect information from users is via email. This is a particularly valuable method for data collection for the purpose of conducting a survey, updating a status report or for managing events. The process is easy; users can send Access data via an email, using forms emailed from Access.
Other People Are Reading
Instructions
-
-
1
Install and configure Microsoft Office Outlook. You cannot request data via email without it. Additionally, you may want to install Office InfoPath 2007, which will allow you to use an easier-to-use form for collecting the data. Without it, you are required to use the HTML form. Additionally, if you suspect that the recipients do not have Office InfoPath, it isn’t worth it to install, as they cannot receive the form without it. Instead, you will need to use the HTML form.
-
2
Verify that all email recipients have Office Outlook.
-
-
3
Open the Access database, and select the table you wish to populate. If populating more than one table, create a query that links the tables and select it. Note that the fields AutoNumber, OLE Object, Attachment, or Multi-valued cannot be collected via email. You must have additional fields available in order to request Access data through email.
-
4
Start the “Collect data through e-mail messages Wizard” by clicking on the “External Data” tab and then “Create E-mail.”
-
5
Click “Next” once the Wizard opens. Select the type of form, such as HTML or InfoPath, and click “Next.”
-
6
Select “Collect new information only” or “Update existing information,” and click “Next.”
-
7
Specify the data you wish to collect by moving the applicable fields from the left box to the right, and click “Next.”
-
8
Elect whether to have the data within the replies automatically imported to the database, set the parameters for processing the replies and then click “Next.”
-
9
Select how to collect the email addresses. You can either select the recipients from Outlook or a database, if you have already stored their information. Click “Next.” Customize your message and click “Next.”
-
10
Click “Create.” This will open an email in Microsoft Office that includes all of the relevant fields for collecting the Access data. Select the recipients and click “Send.” Once the recipient emails back the data, it will automatically import into the database, if you have selected the option to do so.
-
1
