Excel or Outlook - Count Emails in Shared Mailbox/Subfolders by Month Received

[hmltnangel]

Morning All,

First up, is it better to use outlook or Excel to do this? I prefer Excel as thats what everyone uses in the team anyway.

I need a bit of VBA to check a shared mailbox on Outlook, and count the number of emails in a specified month within the Shared Mailbox, and all its subfolders.

The mailbox is called UKSSC, and it has around 30 subfolders.

thanks