How to report from an Outlook Mailbox – Quick and Simple Reporting

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:

  1. Open up Microsoft access and create a new database
  2. Click on External Data > New Data Source > From other Sources > Outlook Folder
  3. Then click on Import and OK
  4. You’ll then be shown the configured accounts in your Outlook application. Expand the mailbox you want to report on, and select the folder
  5. Now you have a data source with all the emails
  6. You can export this into Excel and use to report on email statistics.

That’s all!