By default, Outlook doesn’t support to group the received emails by their durations in month since received, such as 1 month, 2 months and 3 months, etc. This article will introduce how to add the related field and then re-group the received emails via Outlook VBA.
As you can see, Outlook will automatically group and sort the received emails by the received date, including “Today”, “Yesterday”, “Two Weeks Ago”, “Last Month” and “Older” and so on. Thus, some users may want to group the received mails on basis of their durations in month since the received date, such as 1 month, 2 months and 3 months, etc. Apparently, Outlook doesn’t support it in that there is no related field. Fortunately we still can achieve it with Outlook VBA. Read on to get the concrete VBA codes and the elaborate steps.
Group Received Emails by their Durations since Received
- To start with, launch Outlook turn to “Developer” tab.
- Then click on “Visual Basic” button, which will bring out a new window.
- Next in the popup window, open a new module and copy the following codes into it.
Public Sub AddMonthField() Dim olSel As Selection Dim obj As Object Dim olMail As MailItem Dim olProp As Outlook.UserProperty Dim strMonth Set olSel = Outlook.Application.ActiveExplorer.Selection On Error Resume Next For Each obj In olSel If TypeName(obj) = "MailItem" Then Set olMail = obj strMonth = DateDiff("m", olMail.ReceivedTime, Now) Set olProp = olMail.UserProperties.Add("Month", olNumber, True) olProp.Value = strMonth olMail.Save End If Err.Clear Next End Sub
- After that, you can exit the “Visual Basic” window and add the new macro to the Quick Access Toolbar as usual.
- Subsequently, you can back to your Inbox mail folder. Press “Ctrl + A” to select all of them. And then click on the new macro button in Quick Access Toolbar.
- Later you can switch to “View” tab and hit “View Settings” button.
- In the popup dialog box, click “Columns” button.
- Then in the new “Show Columns” dialog box, take the steps below:
- At first, set “Select Available columns from” to “User-defined fields in Inbox”.
- Then select “Month” from the “Available columns” box.
- Next hit “Add” button.
- Optionally, use “Move Up” and “Move Down” button to change the order.
- Lastly click “OK”.
- After clicking “OK”, you will get back to “Advanced View Settings” dialog. Now hit “Group By” button.
- Later in “Group By” dialog box, firstly change “Select available fields from” to “User-defined fields in Inbox”, and then select “Month” from “Group items by” drop down list, and last click a series of “OK” to close all the dialog boxes.
- Finally you can go back to your Inbox folder. You can see that all the emails are grouped by the number of months since their received date. Also, you can click “Month” column to select ascending or descending as per your needs.
Effectively Dispose of Vexing Outlook Errors
Outlook is susceptible to error. Moreover, if you are confronted with any errors, you’d better address them as soon as possible in that accumulating issues will lead to considerably serious consequences, such as Outlook PST mail corruption. If you have no current backups, you’ll have no choice but to employ a well-proven repair tool, like DataNumen Outlook Repair.
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair corrupted SQL Server database and outlook repair software products. For more information visit www.datanumen.com