Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

Easily Count total numbers of emails received in all Inboxes per day with charts in Outlook

Provided by Kutools for Outlook, Click for 60-day free trial without limitation!
doc count emails received today kto 03

Office Tab - Enable Tabbed Editing and Browsing in Office, and Make Work Much Easier...
Kutools for Outlook - Brings 100 Powerful Advanced Features to Microsoft Outlook
  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
  • Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
  • More than 100 advanced features will solve most of your problems in Outlook 2010-2019 and 365. Full features 60-day free trial.

arrow blue right bubble 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.


arrow blue right bubble 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.


arrow blue right bubble 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.


arrow blue right bubble 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:

1. Please click Kutools > Statistics. See screenshot:
doc count emails received today kto 01

2. Now the Statistics dialog box comes out, please select the specified folder from Outlook Folders drop down list, such as Inbox, and click the OK button. See screenshot:
doc count emails received today kto 02

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


arrow blue right bubbleDemo: 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!


Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
  • Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
  • Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121
 
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Laura · 1 months ago
    can you do a date range? and add folders?
  • To post as a guest, your comment is unpublished.
    Artur · 6 months ago
    will this (VBA) works under Outlook 365 ?
    • To post as a guest, your comment is unpublished.
      kellytte · 4 months ago
      Hi Artur,
      This VBA works well in Outlook 365 desktop program.
  • To post as a guest, your comment is unpublished.
    Rajan · 1 years ago
    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 .
  • To post as a guest, your comment is unpublished.
    Balaji G · 3 years ago
    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
    • To post as a guest, your comment is unpublished.
      Dan · 3 years ago
      Did you find a resolution to this?
  • To post as a guest, your comment is unpublished.
    Leo · 3 years ago
    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
    • To post as a guest, your comment is unpublished.
      vin · 1 years ago
      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
  • To post as a guest, your comment is unpublished.
    Vobla · 3 years ago
    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)
  • To post as a guest, your comment is unpublished.
    Shane · 3 years ago
    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
  • To post as a guest, your comment is unpublished.
    Dennis SIms · 4 years ago
    VBA instuctions to be able to create a counter for emails recieves last week
  • To post as a guest, your comment is unpublished.
    sakro · 4 years ago
    very thanks
    i solved all what i need, very thanks again great effort
  • To post as a guest, your comment is unpublished.
    NP · 5 years ago
    This code is great ....

    But I need to show how many emails have been received, in total, on a day, say 1/1/2014, and they may not still be in outlook ?

    Is this possible ....

    As I think this only counts emails that are still in the inboxs, not ones that have been recevied, then deleted .... Can anybody help ? :lol:
    • To post as a guest, your comment is unpublished.
      Kevin Groff · 3 years ago
      I think you need to select the other folders as well for when you move the message from the inbox to deleted items to other folders. It then looks in all those folders, at the date, and counts them. That solved it for me. When you add new folders, you need to add them to your search rule. I dont know the answer for how to easily have it build a system and store a separate folder for each day.
    • To post as a guest, your comment is unpublished.
      Joakim · 5 years ago
      Hi, did you get any replies in the matter, I am searching for the exact same counter?
      • To post as a guest, your comment is unpublished.
        NP · 5 years ago
        No ... still have no fix ... can anybody help ?

        PS. Total emails hitting the mail box each day.
  • To post as a guest, your comment is unpublished.
    mujaed · 5 years ago
    Hi thank you for this, I have used it and works in giving what is total emails inbox but the last message box appears blank and does not give total email for the date. can you help?