I have been asked to find out the reason for an outlook account having such a large filesize, and was wanting to do a macro to export each subfolder name with it's size into excel, to see which is the largest, then use that for suitable archiving.

I have searched and have yet to find anything suitable. Anyone attempted this before?