VBA Code for finding Shared/Group Mailbox folder and sub-folder sizes

Question

I have a Shared/Group Mailbox in my Office Outlook (2010) which contains many sub-folders (as per applications names) apart from my personal Inbox. Shared Mailbox sometime gets overloaded in size as mail comes to Shared Inbox and we have Rules to move particular mail to its corresponding sub-folder.

Can anyone help me with some VBA Code which will mail me (report sort of) with the details of the Sub-folder name and sizes and based on that we will act accordingly (like deleting/archiving etc.)

unfortunately, it's not how this site works. Please start with Google or search here, in SO. Next try something on you own and come back here if you encounter any problem(s). — Kazimierz Jawor
I have tried that way and found only which telles abt my Inbox details. I need Shared Inbox details... — user2776627

niton niton · Accepted Answer · 2013-11-19T13:28:54

When you refer to a folder in the shared mailbox rather than ns.GetDefaultFolder(olFolderInbox).Folders(targetFolder)

Try this more general format

ns.Folders("name of shared mailbox").Folders("Inbox").Folders(targetFolder)

VBA Code for finding Shared/Group Mailbox folder and sub-folder sizes

1 Answers