How to Quickly Count Incoming Emails by Date, Month or Year via Outlook VBA

If you would like to count the number of incoming emails on a specific date, or in a specific month or year, you can use the quick means introduced in this article. It will teach you how to use VBA to get it in a flash.

When it comes to counting how many emails received in specific date or periods, many are accustomed to using Outlook search folder, which permits us to gather all the emails incoming in the specific date or date range in a single search folder. Then we can use the “show total number of items” feature for mail folder to get it. However, without any doubts, this method is quite troublesome. Thus, here we’ll teach you another trick, which can make use of Outlook VBA to help you get the total count. Now read on to learn the detailed steps and codes.

Count Incoming Emails by Date Month or Year

Count Incoming Emails by Date

  1. To start with, launch your Outlook program properly.
  2. Then you can switch to “Developer” tab and click the “Visual Basic” button.
  3. Next in the popup Outlook VBA editor window, you can open a new module by “Insert” > “Module”.
  4. Subsequently, copy the following VBA codes into the new module.
'The following codes are working to count by day
Sub CountReceivedEmailsbyDay()
    Dim objItems As Outlook.Items
    Dim objItem As Object
    Dim objMail As Outlook.MailItem
    Dim strDay As String
    Dim dReceivedTime As Date
    Dim strReceivedDate As String
    Dim i, n As Long
    Dim strMsg As String
    Dim nPrompt As Integer
    Set objItems = Outlook.Application.ActiveExplorer.CurrentFolder.Items
    objItems.SetColumns ("ReceivedTime")
    strDay = InputBox("Enter the specific day.(Format: yyyy-mm-dd)", "Specify Date")
    If strDay <> "" Then
       n = 0
       For i = 1 To objItems.Count
           If objItems.Item(i).Class = olMail Then
              Set objMail = objItems.Item(i)
              dReceivedTime = objMail.ReceivedTime
              strReceivedDate = Year(dReceivedTime) & "-" & Month(dReceivedTime) & "-" & Day(dReceivedTime)
              If strReceivedDate = strDay Then
                 n = n + 1
              End If
           End If
       Next i
       strMsg = "You have received " & n & " emails on " & strDay & "."
       nPrompt = MsgBox(strMsg, vbExclamation, "Count Received Emails")
       nPrompt = MsgBox("Please input the specific day!", vbExclamation)
    End If
End Sub

VBA Codes - Count Incoming Emails by Date

Note: This above code is working to count the incoming emails by date.

  1. After that, you can add the new macro to Quick Access Toolbar as usual.
  2. Finally, you can have a try.
  • Firstly, select the Inbox folder.
  • Then click on the button in Quick Access Toolbar.Run Macro
  • Next you need to input a specific date in the format of “yyyy-mm-dd”.Specify the Date
  • Lastly, you will receive a prompt of the total count, like the image below:Count Incoming Emails by Date

Count Incoming Emails by Month or Year

As the above code is specified for counting by day, if you want to count by month or year, you need to make some changes on the codes.

  1. Firstly, change all “strDay” to strMonth or strYear.
  2. Secondly, replace the line “strDay = InputBox(“Enter the specific day.(Format: yyyy-mm-dd)”, “Specify Date”)” with:
  • strMonth = InputBox(“Enter the specific month.(Format: yyyy-mm)”, “Specify Month”)
  • strYear = InputBox(“Enter the specific year.(Format: yyyy)”, “Specify Year”)
  1. Thirdly, change the line “strReceivedDate = Year(dReceivedTime) & “-” & Month(dReceivedTime) & “-” & Day(dReceivedTime)” to:
  • strReceivedDate = Year(dReceivedTime) & “-” & Month(dReceivedTime) [for month]
  • strReceivedDate = Year(dReceivedTime) [for year].

What Will Occur after Outlook Crashes

Many users have ever suffered Outlook crash. At best, after restarting Outlook, all things will get restored, namely nothing will happen. However, at worst, you may encounter severe PST corruption. At that point, assuming you don’t have current data backups, your last resort is, unquestionably, a remarkable repair tool, such as DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and outlook repair software products. For more information visit

One response to “How to Quickly Count Incoming Emails by Date, Month or Year via Outlook VBA”

  1. Sign up with 100% cost-free Vietnam dating conversation site page and also Meet Vietnam children. VietnamCupid is an Asian dating site you require to inspect out if you’re in Southeast Asia right currently or ready to fly there to satisfy the perfect Vietnamese lady! To get a long-term relationship with a Vietnamese female, you have to be major and also have persistence. By utilizing the Vietnamese dating websites suggested in my guide and following my perk tips for dating a Vietnamese lady, you give on your own the ideal opportunity of satisfying your Vietnamese desire lady(s). Vietnamese dating websites are the finest locations to locate your dream companion without a relevant payment of costs. You can check out credible dating sites or matchmaking solutions if you’re looking to locate stunning Vietnamese mail-order brides. That implies you won’t locate a lot of phonies or flakes on YMeetMe. Free participants are limited to communicating just with paid customers, so you’ll desire a Gold or Platinum membership in order to exchange messages with any one of the beautiful Oriental women you’ll find on the website. You’ll require either a platinum or a gold membership if you desire the capability to connect with any kind of lovely Vietnamese single who catches your eye. The Gold subscription on VietnamCupid begins around $30 for a one month, while the Platinum subscription costs around $35 for a month.

    Whenever you do among these actions, VietnamCupid will inform them, and also they can visit your account or respond. It’s essentially the very same structure as VietnamCupid – you can develop an account as well as search for appealing Eastern songs for free. The cost of a premium subscription is the same on both international dating websites. Whether you’re dating in Vietnam or looking to locate high-quality Vietnamese songs prior to booking your trip, the last point you wish to do is waste your time with dating websites as well as apps that do not obtain outcomes. Do not waste any more time, and start with the third ideas from this short article – discovering a few simple Vietnamese words as well as expressions that you can utilize to start a conversation. By adhering to the 3 pointers from this article, you will certainly be able to make the entire process of coming close to a Vietnamese woman less complicated and much less overwhelming. Where can you meet Vietnamese female?

    Connection in Vietnamese can be group in a number of phases; most base of a partnership is a pleasant day. You may be asking yourself why is it similar to this, well, most men are frightened of falling short when starting a discussion with a lady. Obviously, you do not have to learn the entire language, yet a couple of expressions and also words like “hello”, “just how are you”, and “goodbye” are good for beginning a conversation. Great cost-free dating websites include elements that you yourself only understand. You will slowly get her depend on by great treatment of her every single time you go out with her. If you are severe concerning dating a Vietnamese girl, you should additionally spend your time in finding out some local Vietnamese words as well as expressions. When Vietnamese women upload their individual ads online, several of them do not release their pictures since they fear that their faces in public. An account is an individual ad that defines that you are. You write something on your profile, including name, age, interests, pastimes, careers, likes, disapproval, and so on. You can also upload some images on your personal advertisement to draw in various other songs. When check in, you can see that’s online, who’s brand-new to the site and that has actually revealed passion to you-so you can quickly and promptly discover various other songs that you might have an interest in.

    Vietnamese songs likewise like to interact online as a whole. Because Vietnamese wives more than happy to make every fantasy come true. Anyhow, there are thousands of Vietnamese women that register online to look companions; you will discover the most effective one. A common myth is that every Vietnamese mail order bride that is attempting to obtain wed to a foreigner wants nothing but cash, key, visa, expensive presents, and a deluxe way of living. For other females in Vietnam, the reason that they are eager to meet an immigrant is purely social. Unlike Western women, most Oriental brides think that they should do every little thing to conserve their family, as well as this is the reason these ladies can forgive their other halves a whole lot. If you have actually been to Vietnam prior to, you might have discovered that a lot of Vietnamese ladies have a hard time talking English. Vietnamese females live not only in Vietnam, but you can additionally find them in a whole lot of countries. Any guy would call the ordinary Vietnamese lady lovely, and also Vietnamese other half finder firms are cognizant of this.

Leave a Reply

Your email address will not be published. Required fields are marked *