Skip to main content

How to count total number of incoming emails per day in Outlook?

Have you ever counted the total number of emails that you received per day? And are you fed up with counting them one by one manually without any efficient methods? In this tutorial, we provide you with two tricks for counting total emails per day in Outlook.


Count total number of emails incoming today with Instant Search feature

Actually, it's quite easy to search all emails incoming today into the Inbox folder, all folders of an email account, or all folders of all email accounts in Outlook, and then count the total number of the search results. Please do as follows:

In the Mail view, (1) select the Inbox folder of one email account that you will count incoming emails today; (2) type the search criteria received:Today into the Instant Search box, and then (3) specify a search scope in the Scope group on the Search tab. See screenshot:

And now the total number of all search results, in other words the total number of emails incoming today displays at the bottom-left corner of Outlook as below screenshot shown.

One click to count the number of selected emails in Outlook

It's easy to get the total number of all items or the number of unread items in an Outlook folder. But how could you quickly get the number of selected items in a folder in Outlook? Here, Kutools for Outlook's Count Selected Items is recommended, which can quickly show the number of selected items by only one click!


Count total number of emails incoming today with Search Folder feature

This method will guide you to create a search folder which automatically collects all emails received today, and then you can get the total number of these emails with change the search folder's properties. Please do as follows:

1. Select the email account that you will create a search folder within on the Navigation Pane, and click Folder > New Search Folder. See screenshot:

2. In the New Search Folder dialog, select the Create a custom Search Folder option, and click the Choose button. See screenshot:

3. Now the Custom Search Folder dialog box comes out. Please name the new search folder in the Name box.

4. Go ahead to click the Criteria button in the Custom Search Folder. Now In the Search Folder Criteria dialog box, (1) click Message tab, (2) select received from the Time drop down list, (3) specify Today from the following drop down list, and then (4) click the OK button. See screenshot:

5. Now it returns to the Custom Search Folder dialog, please click Browse button. And then In the Select Folder(s) dialog box, (1) please only check Inbox in the Folders list box, check Search Subfolders option, and click the OK button. See screenshot:

6. And then click OK buttons successively to close the Custom Search Folder dialog box and New Search Folder dialog box.

7. Right click the new search folder you created just now, and then select Properties from the right-clicking menu. See screenshot:

8. In the following dialog, check the Show total numbers of items option, and then click the OK button. See screenshot:

From now on, the copies of the incoming email messages will be saved to this search folder per day. If a new day is coming, the search folder will automatically remove all the old messages and start counting the new days email messages.

Note: This method can only count the total number of emails received today in Inbox of one email account.


Count total number of emails incoming on a certain date with VBA

Besides the above method, you can use VBA code to count total emails on a certain date in Outlook. Please do as follows.

1. Select the folder that you want to count the total incoming emails per day, and then open the Microsoft Visual Basic for Applications by pressing Alt + F11.

2. Then please Insert > Module to insert a new module, and then paste below VBA code into it.

VBA: Count total emails per day

Sub Countemailsperday()
    Dim objOutlook As Object, objnSpace As Object, objFolder As MAPIFolder
    Dim EmailCount As Integer
    Dim oDate As String
    
    oDate = InputBox("Type the date for count (format YYYY-m-d")
    Set objOutlook = CreateObject("Outlook.Application")
    Set objnSpace = objOutlook.GetNamespace("MAPI")
        On Error Resume Next
        Set objFolder = Application.ActiveExplorer.CurrentFolder
        If Err.Number <> 0 Then
        Err.Clear
        MsgBox "No such folder."
        Exit Sub
        End If
    EmailCount = objFolder.Items.Count
    MsgBox "Number of emails in the folder: " & EmailCount, , "email count"
    Dim ssitem As MailItem
    Dim dateStr As String
    Dim myItems As Outlook.Items
    Dim dict As Object
    Dim msg As String
    Set dict = CreateObject("Scripting.Dictionary")
    Set myItems = objFolder.Items
    myItems.SetColumns ("ReceivedTime")
    ' Determine date of each message:
    For Each myItem In myItems
        dateStr = GetDate(myItem.ReceivedTime)
        If dateStr = oDate Then
            If Not dict.Exists(dateStr) Then
                dict(dateStr) = 0
            End If
            dict(dateStr) = CLng(dict(dateStr)) + 1
        End If
    Next myItem
    ' Output counts per day:
    msg = ""
    For Each o In dict.Keys
        msg = msg & o & ": " & dict(o) & " items" & vbCrLf
    Next
    MsgBox msg
    Set objFolder = Nothing
    Set objnSpace = Nothing
    Set objOutlook = Nothing
End Sub
Function GetDate(dt As Date) As String
    GetDate = Year(dt) & "-" & Month(dt) & "-" & Day(dt)
End Function

3. After pasting the VBA code, please click Run button.

4. Then enter the specified date you want to count the total incoming emails in the popping out dialog box, and then click OK. See screenshot:

5. A dialog box prompts to show the total number of emails in the selected folder, please click the OK button. And in the second popping out dialog box, you will get the total number of emails received today. See screenshots:

Notes:
(1) This VBA can only count the total number of all email received on the specified date in the selected folder;
(2) This VBA code works well in Outlook 2010, 2013, and 2016.


Count total number of emails incoming per day with Kutools for Outlook

If you have Kutools for Outlook installed, you can apply its Statistics feature to easily count the total numbers of emails received per day in a month. Please do as follows:

Kutools for Outlook: Ultimate Outlook toolkit with over 100 handy tools. Try it FREE for 60 days, no limitations, no worries!   Read More...   Start Free Trial Now!

1. Please click Kutools Plus > Statistics. See screenshot:

2. Now the Statistics dialog box comes out, please select the specified folders you will count emails in, specify the date range you will count emails within, and click the OK button. See screenshot:

3. In the second Statistic dialog box, go to the Days of Month tab or Days of Week tab, you can view the total number of emails received on each date. See screenshot:
Btw, you can also get the total number of emails received today/yesterday in all Inbox folders of all email accounts on the Summary tab.


Demo: Count total number of emails incoming per day with Kutools for Outlook


Tip: In this Video, Kutools tab is added by Kutools for Outlook. If you need it, please click here to have a 60-day free trial without limitation!


Related articles:


Best Office Productivity Tools

Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook

🤖 AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 Email Automation: Out of Office (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

📨 Email Management: Easily Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

📁 Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Boost Your Outlook Productivity with Tabbed Views  /  Minimize Outlook Instead of Closing ...

👍 One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  🕘Show Sender's Time Zone ...

👩🏼‍🤝‍👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Over 100 Features Await Your Exploration! Click Here to Discover More.

Read More       Free Download      Purchase
 

 

Comments (19)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Is there a way to add the SenderName details too? Based on the above code, it counts emails by date. I was looking to count emails by sender and date.
This comment was minimized by the moderator on the site
can you do a date range? and add folders?
This comment was minimized by the moderator on the site
Hi Laura,
You can filter emails by the date range (https://www.extendoffice.com/documents/outlook/1412-outlook-search-date-range.html), and then get the total number of search results at the bottom of Outlook Navigation Pane.
This comment was minimized by the moderator on the site
will this (VBA) works under Outlook 365 ?
This comment was minimized by the moderator on the site
Hi Artur,
This VBA works well in Outlook 365 desktop program.
This comment was minimized by the moderator on the site
guys i have tried this code just now but it is not working can anyone help me . i want to count the num of email i received in my oracle folder .
This comment was minimized by the moderator on the site
Hi this vba script is most appreciated, Can anyone help me to retrieve the count from specific folder with specific time, Ex: Count from sent items from dd/mm/yyyy mm:hh till dd/mm/yyyy mm:hh
This comment was minimized by the moderator on the site
Did you find a resolution to this?
This comment was minimized by the moderator on the site
Hi guys, any idea how to make this work for a period o time? I mean, selecting a range date (from-to) and getting the result per day e.g inpunt range from June 1st to june 6th: 6/1 total 14 6/2 total 24 6/3 total 12 and so on... thanks in advance
This comment was minimized by the moderator on the site
in my case i was able to figure it out by doing it manually. like you can count it per month or per year.
if you will count if per month, just delete the day in the formula

e.g:
Function GetDate(dt As Date) As String
GetDate = Year(dt) & "-" & Month(dt)
End Function


per year:
Function GetDate(dt As Date) As String
GetDate = Year(dt)
End Function
This comment was minimized by the moderator on the site
For me the last window worked when I set both dates into the same format. I chnaged the code into this me (Ru date/time format in Windows, US - in Outlook): 1) oDate = Date 2) ' Determine date of each message: For Each MyItem In myItems dateStr = DateValue(MyItem.ReceivedTime) 3) GetDate = Day(dt) & "." & Month(dt) & "." & Year(dt)
This comment was minimized by the moderator on the site
Hi , Very useful code , but like above it does not count per day for me and last message box is empty , can anyone fix this please
This comment was minimized by the moderator on the site
VBA instuctions to be able to create a counter for emails recieves last week
This comment was minimized by the moderator on the site
very thanks i solved all what i need, very thanks again great effort
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations