Thread: Outlook mail analytics

I suspect you would find it simplest to simply identify the folder of interest and then let the code iterate the mail items retrieving all relevent info (sender, time, subject etc) - you can run a pivot table off this data and analyse however you see fit.

If this is for you and you alone I would suggest using Early Binding to simplify the process - ie reference the Outlook Object Library via VBE -> Tools -> References ... this will make coding easier as you will have Intellisense as you go along.

Attached is a very rough concept...

Programming with OL is not really my forte so I'm sure it can be improved.

Remember to reference the appropriate library - the attached was coded in 2007 so it will list a MISSING reference when you open on 2003 machine - deselect the MISSING library and reference the 11.0 library instead...

If you were looking to roll this type of thing out you'd want to look at controlling the above if using Early Binding else consider Late Binding.

odd though this will sound (and suspicious) I also came across the below which is in effect working the opposite way around - ie code resides in OL to control XL which may in fact be more along the lines of what you want - the code is VERY similar to mine but I promise I didn't plagiarise (this code will be more robust than mine for sure)

http://blogs.techrepublic.com.com/msoffice/?p=744