Separate VBA Macro’s to Count Emails in a Shared Mailbox in Outlook, from the previous 7 days (ie week) and previous 30 days (ie month)

[ndewitt99]

I am looking to insert a macro into outlook to perform the count of folders within the Inbox of a Shared Mailbox. These counts would need to happen on a weekly basis and monthly basis (hence the need for 2 separate macros - unless it can be done in 1 macro). I have tried a count macro before and got success but I need, specifically, the last week and month. Additionally, if anyone could help with how to get the macro to export the count into an existing excel worksheet, so all the data is one big excel file. This would export to an excel file and just input into the column next to the data already there. I hope that makes sense lol. I can clairfy if anyone has any further questions

 

[ndewitt99]

I would really appreciate any help anyone can provide.