Count Number Of Emails by Sender & Date With VBA

well one thing that doesn't make sense here is that you are dec'ing a MAPI namespace and you're not even using it.

but, that point aside, you are apparently using the dictionary object to get your outlook info. and that's fine. personally I don't use it, ever. and you are getting the data you already have by getting the keys. so, is there anything you can possibly get from these articles?

https://docs.microsoft.com/en-us/off...tionary-object

https://docs.microsoft.com/en-us/off...lp/keys-method

and you obviously know how to point to a folder in any given PST, considering you wrote this line:

Please Login or Register  to view this content.

what you can do, I believe, is loop through your mail items and get the sender of each by capturing the sender property. see here:

https://docs.microsoft.com/en-us/off...ailitem.sender

Thank you.

I've declared MAPI namespace and not used it for objFolder because the overall logic goes by looping through all folders and subfolders and I left that part out here as it was not necessary.

nice. so do you need more assistance?