Can an Excel Macro count categories in Outlook 2007 from a shared mailbox?

[Si1209]

Pretty new with VBA so other than doing things from Excel i'm stumped.

I'm looking at different ways in which this may work so also posted something similar in the Outlook section of the forum. On a regular basis we will count the amount of emails worked by category..red/yellow etc and input these details in to a spreadsheet. The mailboxes are shared and need to count for the worked items that day, we do have a worked box which is emptied daily anyway. One potential issue we may have though is that some colleagues are still on 2003 outlook while some are on 2007 so not sure if the categories and flag thing could create issues when trying to count?

Any help would be apprerciated.

Thanks

[SamT]

Copied from other thread before I deleted it

Hello

Need some help please. We have shared mailboxes at work and we need to do a quick count of how many emails have been worked by certain categories, yellow, red etc.

Normally we just use simple manual counting but I was wondering if its possible to have a macro to do this for us?

Thanks