Microsoft Outlook Email Delay Link a Microsoft Access Database to Microsoft Outlook Data

Provided by Dave Juth, Senior Systems Architect

Did you know you can link data from Microsoft Outlook into a Microsoft Access database? Get the list of contacts, calendar items, mail messages, notes, tasks, etc.
To do this, follow these steps from your Microsoft Access database.

From Microsoft Access 2016, 2013, 2010, or 2007

Choose External Data, More, Outlook Folder:

Microsoft Access Link to Outlook

From Access 2003 or earlier

Select from the menu: File, Get External Data, Link Tables. In the Files of Type dropdown, select Outlook.

On the next screen, choose the connection type. For our example, we'll choose "Link to the data source by creating a linked table" to always have the latest data:

Microsoft Access Link to Microsoft Outlook Data Wizard

The next dialog of the Wizard lets you expand the treeview of your Outlook folders:

Microsoft Outlook Folders to Link

Expand the Address Book, Mailbox, or Public Folders and select the data to link into Microsoft Access as a table. For example, to link Contacts data, expand your mailbox and select the Contacts node. Click Next.

In the last form of the Wizard, specify your linked table name, press Finish:

Microsoft Access Link to Microsoft Outlook Contacts Table

When the Link/Exchange Wizard prompts you with the finished dialog, click the OK button and you will see the linked table in your database:

Microsoft Access Database Table Linked to Outlook Contacts List

You can now use and query your Microsoft Outlook data similar to other linked tables.

Microsoft Outlook Tips and Techniques

Microsoft Outlook Messages and Microsoft 365

Microsoft Outlook Calendar

Microsoft Access and Microsoft Outlook

Free Product Catalog from FMS