Microsoft® Office Access™ 2007 Plain & Simple

Collecting Data from E-mail Messages

Gathering data from one’s colleagues, vendors, and customers can be a frustrating process. When you ask a question by phone, in person, or over e-mail, you end up transcribing the responses and typing them into your database. The potential for inaccuracies, mistranscriptions, and other mistakes abound. One of the most useful new things you can do in Access 2007 is to create Outlook 2007 messages that contain Access forms. You send the form to a colleague as an e-mail message, which the recipient fills out and sends back. You can then read the data directly from Outlook into your Access table. You never have to touch the data with your hands, which means that you don’t have to worry about making a mistake as ...