Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Overprinting Watermarks on Documents You can easily insert a watermark into your document in Microsoft Office Word 2007. Click Watermark from the Page Layout tab on the Ribbon. Lookups and Relationships Often you need to add fields that look up data from other tables. For example, you may want to assign a task to someone in your Contacts table. To add such a field: 1. In datasheet view, on the Ribbon, in the Fields and Columns section, click Lookup Column. 2. If you want to type the lookup values instead of looking up a field from a different table, select I will type in the values; if not, click Next. 3. Select the table that you want to look up from, and then click Next. 4. Select the fields that you want to include in your lookup, and then click Next. 5. Select the sorting method you want, click Next, and then click Next again on the following screen. 6. Label the lookup column and check the box if you want to allow the selection of multiple values. Click Finish. • 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 © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement