Outlook statistics of received emails in an email folder using VBA

Outlook statistics with VBA

Have you ever wondered how many emails you get everyday or send ever day? Nearly 43% of my time went in reading and responding to emails. That is a lot of time away from core development. There weren’t software I could find online to run outlook statistics about the number of emails I sent, break it down by date dimension or by sender or by subject. So I decided to take snippets of code, analyze the Outlook model and roll my own VBA; one could very well do with C# COM Interop. Finally, I just chose to use VBA for fun.

outlook statistics

This process can be modified to list out properties of all emails from all folders and run thorough statistics.