Have you ever wanted to report on an Outlook mailbox? There is a simple way using Microsoft Access to report on the emails in any mailbox and folder.
There are solutions out there to access reporting through an admin console, however there is a simpler way.
Simply:
- Open up Microsoft access and create a new database
- Click on External Data > New Data Source > From other Sources > Outlook Folder
- Then click on Import and OK
- You’ll then be shown the configured accounts in your Outlook application. Expand the mailbox you want to report on, and select the folder
- Now you have a data source with all the emails
- You can export this into Excel and use to report on email statistics.
That’s all!