Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile To Change the Color of a Sheet Tab 1. Right-click the sheet tab. 2. Click Tab Color. 3. Click the color from the palette that appears. Collecting Data via E-Mail Microsoft Office Access 2007 simplifies the process of collecting information from others. It builds the data collection form automatically by using Microsoft Office InfoPath 2007 or HTML in the body of an e-mail message. Microsoft Office Outlook 2007 processes the incoming forms and helps you save the data in your Office Access 2007 data store—effectively updating the database without retyping. To collect new information via e-mail: 1. Open or select the table containing the fields that you want to collect. 2. On the External Data tab, click Create E-mail. 3. Follow the wizard to create an e-mail form. a. Select HTML or InfoPath form (if you select the latter, the recipients must have Office InfoPath 2007 and Office Outlook 2007 deployed). b. Select Automatically process replies and add data to Table if you don't have to approve each entry before it is saved in the database. Returned forms will go to a newly created folder named Access Data Collections in your Inbox in Office Outlook 2007. Each time you receive a filled form, it will be flagged as a task for you to review. To export collected data to Access: 1. If you have not selected automatic processing, right-click the returned e-mail message, and then click Export to Access. Or you can open the message and click the same command from the Ribbon. 2. Green or red icons will flag whether the export was successful or not. After sending a data collection e-mail message, you can use the Manage Replies command on the External Data tab of the Ribbon to change some of the message options and resend the message. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2008 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement