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.
Choose External Data, More, Outlook Folder:
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:
The next dialog of the Wizard lets you expand the treeview of your Outlook folders:
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:
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:
You can now use and query your Microsoft Outlook data similar to other linked tables.
"I was thrilled with how easy it was to run and I appreciated that I didn't need to build any special tables or queries."
Microsoft Access MVP