From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Linking Outlook contacts - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Linking Outlook contacts
If you would like to use your Access database to manage contacts who are in your Outlook, you can create a Link Table that will pull in your contacts. If you make any changes in Access, they'll be reflected in your Outlook as well. Go to the third tab for External Data and drop down the button that says More. On that list you'll find Outlook Folder, click on it. You have the option of doing a one time import of your contacts or you can link to the data source, which will create a live link between the two. Click OK. We're looking at our Outlook, and I will click the plus sign next to Address Books. I will also click the plus sign next to Outlook Address Book and then click on Contacts, and click Next. I am going to modify the name here to Outlook Contacts, that way I know that the people in this file have a live link to my Outlook. I will click Finish. I get a confirmation message. I will click OK. Here's my new table. The icon shows me that it's pulling from my e-mail and this little…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Undo and Redo tips2m 26s
-
Entering data across, not down1m 6s
-
Repeating data from the record above1m 54s
-
Inserting today's date1m 14s
-
Removing automatic hyperlinks1m 52s
-
Using AutoCorrect1m 45s
-
Using concatenated fields8m 56s
-
Linking Outlook contacts2m 38s
-
Saving imports and exports for reuse5m 22s
-
-
-
-
-
-
-
-
-
-