Count emails in Outlook before set date

Hi all,

I am working on improving one of my work documents where I count a lot of emails that are incoming and as well as counting backlogs.
I have a working macro that counts all the received during a certain date that I enter as a value, however I am not sure how I can count the backlog.

What I want to do is:

I click a button connected to the macro, the macro as an inputbox asking me for a value, the value being a specfic date in the "dd/mm/yyyy" format. The macro then goes into the specified outlook folder and counts all the emails that arrived BEFORE this date.

I am not sure if it can help but below here is the macro for counting emails for a specific date

Please Login or Register  to view this content.

Thankful for any help I can get

Hi,

If you only need to count these emails then I think it would be easier to use the advanced filter.
You won't need to loop through all emails in the folder to get the count, so if you are using this to handle large numbers of emails you should see improvement in speed as well.
Basically, this method works the same as if you typed your search criteria into Outlook search box and read the number of results from the status bar.
I've modified your code below, see if it works for you.
The backlog count is displayed in a message box, change this to wherever you need it.
Lastly, the inputbox will currently accept any input so you are probably right leaving the error handler on till the end of the code, but that's not ideal.

Greetings from Bray!

Please Login or Register  to view this content.

Thanks dOOb!

The code works very nicely for the backlog count, however there is something I cannot seem to work out.
When I am trying to have it count only date that was inputted, it always returns zero, and I am not really sure why.

sorry, my bad, the date must be specified using ">= yourdate and <= yourdate plus the upper time limit" instead of just "="
replace that part of the code with the below and it should fix it:

Please Login or Register  to view this content.

Thanks! That works perfectly!
I haven't tried it on the most email heavy mailbox yet but the speed is really fast so thanks for that as well!