Share this Page URL
Help

Chapter 15. Integration with Office 2003... > Working with Outlook Data in Access - Pg. 561

Integration with Office 2003 and SharePoint Services 561 6. 7. Notice that you can link to every type of Outlook object, including Notes, Tasks, and even the Journal. Access will prompt you for a linked table name. Leave the default name (Contacts), and make sure the I Would Like The Wizard To Store My MAPI Profile Name With My Linked Table check box is selected. Click Finish. Access then will link to the Outlook object and notify you that the link is complete. Click OK. You'll now see, in the Access Database window under Tables, a new linked table named Contacts (with a special icon that represents the type of Outlook object it is). If you open the table, you'll see all of your Outlook contact information. You can manipulate the table, change it, run queries against it, and organize it just as you would any other linked table. Global updates are now a snap! You can even run reports against your Outlook objects. How many contacts do you have in Ohio? A quick Access query will tell you. Just the Steps Link to Outlook contacts from Access 1. 2. 3. 4. 5. From within Access, click File, Get External Data, and then click Link Tables. In the Link dialog box, select Outlook() in the Files Of Type drop-down list. Select the Outlook object to which you want to link, and click Next. Select the I Would Like The Wizard To Store My MAPI Profile Name With My Linked Table check box, and click Finish. Click OK in the link notification dialog box.