Count Emails in Outlook and export to excel

[bmeye4]

I am trying to count the amount of emails, in real time, in a subfolder in Outlook 2013 and automatically export the data to excel. I don't mind opening the excel document and refreshing the data daily, if needed.
The subfolder is called "disks" - it is in a group mailbox subfolder. Any ideas?

 

[JACOBB9900]

Why don't you recommend the alternative method?

 

[DanteAmor]

Why don't you recommend the alternative method?

Because the macro would always be running and that uses resources from your machine.