Pages

Tuesday, June 17, 2008

Link Outlook contacts to an Access database

You can quickly copy or link to your Outlook contacts in an Access database, enabling you to work with your Outlook contacts in an Access database. Your Access data is kept up to date with changes to Outlook contacts, and vice versa, if you choose to link contacts to Access.
1. Open Access and start a new, blank database or open an existing database.
2. Do one of the following:
§ On the File menu, point to Get External Data, and then click Import.
§ On the File menu, point to Get External Data, and then click Link Tables.
Note If you link Outlook data to Access, any items updated in Outlook are automatically updated in Access.
3. In the Link or Import dialog box, in the Files of Type list, click Outlook.
If you have more than one Outlook profile, you are prompted for which profile to use.
4. In the Import Exchange/Outlook Wizard, select the folder or address book that contains the contacts that you want, and then click Next.

Expand the top mailbox folder.

Select the folder that contains the contacts that you want to export.

When you complete the wizard, the Outlook data is placed into an Access table.
5. Follow the instructions on your screen.

I want to share my experience with Outlook Support, Email Support and Fix Email problems Online

No comments: