Count Emails in a folder by Date

I found a good macro online for counting emails in a folder by date, but there's some clunkiness to it I'd like to rectify but don't know how. The way I currently have it configured is shown below. The first thing I'd like to change is the folder designation portion. As you can see, I have to dive deep into the folders to pull out the info I want. It would be much better if I could just run this on my selected folder, but don't now how to code for that (not very proficient at Outlook coding).

The second part I'd like to change is the output; Currently it outputs to a MsgBox, but I'd prefer a hardcopy version, either an Excel Workbook or Notepad. Again, not sure how to go from here to there. Any help would be greatly appreciated.

Please Login or Register  to view this content.

For the first part, perhaps this

Please Login or Register  to view this content.

For the second part, do you have a preference?

Wow, that first part was certainly easy enough. Thanks. For the second, I'm much more familiar with Excel, so that would be my preference.

Perhaps replace this section

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

And again you rock my world. That does the trick nicely. I'll do a little formatting tweaks, but you've nailed down my two problem areas. Thank you so much!

You're welcome.

Updated, full code is below:

Please Login or Register  to view this content.

It might be wise to add an

Please Login or Register  to view this content.

around the output part so you don't waste time with a blank worksheet if there weren't any relevant items in Outlook.

Good call. I updated my full code example above.