Count Selected Items in Outlook

Total Views : 243
Zoom In Zoom Out Read Later Print

I’ve selected a lot of items and want to know how many they are, but how can I count them automatically? Windows shows in the Status Bar the amount of selected items in explorer but Outlook doesn’t. Let's us show you how you can do this.

Outlook has no way of telling you that but indeed just continues to display the total amount of items in the folder.
You can do this in two way first one is simple but you have to be more careful with first one because one wrong action can make your outlook stopped .there is actually a native alert feature we can use here which will give the same results. Second way to do this is creating a macro. Writing some code to display the amount of selected items in a message box is not that hard to do.

#1 Count Selected Emails in Outlook 

1. Open Outlook (No need if already done).
2. Select emails you want to count.
3. Press Enter

4. Click on No to close this alert dialog because if you don't want to open all emails opened.

#2 Count Selected Emails in Outlook using VBA Macro

1. Open the VBA Editor (ALT+F11)
2. Write following code in editor.

CountItems()

Sub CountItems()
    Dim eSelection As Outlook.Selection
    Dim result As Integer
    Set eSelection = Application.ActiveExplorer.Selection
    result = MsgBox("Number of Selected Emails: " & _
                eSelection.Count, vbInformation, "Selected Items")
End Sub

3. Add a button for easy access to the macro.
4. Sign your code.

Check URL in step 4 and 5 to know the step for adding a button or macro and signing code.

See More

Latest Photos