If you are using Outlook 2007 or Outlook 2010 and Microsoft Access 2007 or Access 2010 you can create an e-mail message from Access that incorporates a form asking the recipient for specific items required for the database. When the relevant information is sent to you it can then be appended to the database or used to update existing records.
To collect Access data by e-mail:
In the Navigation Pane, select the table for which you want to collect data by e-mail.
Click the External Data tab, then in the Collect Data group, click Create E-mail. The Collect data through e-mail wizard will be displayed.
Click Next. Select either Microsoft Office InfoPath or HTML form. (If you do not have InfoPath installed on your computer, that option will be disabled.)
Click Next. Select either Collect new information only to collect data to be appended to the existing table or Update existing information to make changes to the data in the existing table.
Click Next. Select the fields to be included in the form.
Click Next. Check Automatically process replies and add data to the table. This means that data will automatically be added to the existing database table when e-mails containing data are received.
Click Next. Decide whether you are going to Enter the e-mail addresses in Microsoft Office Outlook or Use the e-mail addresses stored in a field in the database.
Click Next. Enter a suitable subject line and body text for the e-mail message you are going to send.
Click Next. Click Create. You will then see the e-mail message.
Type in the recipient names and press Send.
Find more details of our Microsoft Access training courses in Sydney, Australia.
Find details of our Microsoft Outlook training courses in Sydney, Australia.
Find details of our Microsoft Access training courses in London, UK.
Find details of our Microsoft Outlook training courses in London, UK.