Generate folder reports

[OG]

Hi,
I am responsable for a huge Outlook 2002 inbox.
I am trying to find out if it is possible to generate
reports for each folder. I just need outlook to maybe
populate an excel spreadsheet with the number of emails
directed to each of my outlook folders during a specific
time frame (weekly/monthly reports).
Any ideas how to do this?
Any help or advice would be much appreciated.
Thank you.

 

[Eric Legault [MVP - Outlook]]

Of course there is no built-in way to do this, but it can be done with some
macros.

- Loop through the Messages collection in the desired folder(s)
- Get Messages.Count for the report
- check the ReceivedTime value of each message in the loop, comparing values
for your time criteria and counting for each criteria
- use the Microsoft Excel Object Library to create/reference a Workbook
object and write the values from your code into a WorkSheet object
- repeat for each folder

You can find lots of code samples to build this at http://www.outlookcode.com.

 

[OG]

Thank you for your help Eric.
It gives me food for thought. am no progranner so will do my best.

Regards,

Oli