Skip to main content

How to count the number of recipients in To, Cc, and Bcc fields in Outlook?

Let’s say you add many recipients in the To, Cc, and Bcc fields in a composing email in Outlook, and now you want to count the total number of recipients, how? Below method will introduce a VBA to count the total number of recipients in the To, Cc, and Bcc fields.

Easily count numbers of received emails per day/week/month, and report in chart

Kutools for Outlook release a new feature of Statistics, which can help you easily count received by day/week/month, count the number of selected emails, count the number of all items in all folders, etc., and report the counting results in Charts as following screenshot shown.

count emails per day

Office Tab - Enable Tabbed Editing and Browsing in Microsoft Office, Making Work a Breeze
Kutools for Outlook - Boost Outlook with 100+ Advanced Features for Superior Efficiency
Boost your Outlook 2021 - 2010 or Outlook 365 with these advanced features. Enjoy a comprehensive 60-day free trial and elevate your email experience!

arrow blue right bubble Count the number of recipients in To, Cc, and Bcc fields with VBA

This method will introduce a VBA macro to count the total number of recipients you added in the To, Cc, and Bcc fields in a composing email. Please do as follows:

1. After adding recipients in the composing email, please press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and then paste below VBA code into the opening Module window.

VBA: Count the number of all recipients

' Count all recipients in To, Cc, and Bcc fields
Sub Hurriedness()
If (Inspectors. Count > 0) Then Msg Box (ActiveInspector.CurrentItem.Recipients.ount) & " Recipients"
End Sub

3. Press the F5 key or click the Run button to run this VBA.

Now a dialog box will come out and display how many recipients you have added in the To, Cc, and Bcc fields.

Notes:

(1) This VBA code will count a contact group as one recipient;

(2) This VBA code will count duplicate recipients repeatedly. For example, you have added the same recipient into both the To field and Cc filed, this code will count this recipients twice.

(3) For counting the total number of recipients excluding duplicate ones, we recommend you remove duplicate recipients with Kutools for Outlook’s Duplicate Names feature before running the VBA code.

One click to remove all duplicate recipients from the To/Cc/Bcc fields in Outlook

Sometimes, you may add many recipients when composing an email in Outlook, and duplicate recipients are likely to come out in the To/Cc/Bcc fields. With Kutools for Outlook's Duplicate Names feature, you can quickly remove any duplicate recipients from he To filed, Cc field, and Bcc fields in an composing email. See screenshot below.

remove dupliacte recipientse email


arrow blue right bubbleCount the total number of all recipients you have sent emails to

Above method will count the total number of all recipients you will send to in the currently composing email in Outlook. But, this method will Introduce Kutools for Outlook’s Add to Group feature and Count (Contact Group) feature to help you count the total number of all recipients you have sent emails to in the Sent Items folder. 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. In the Mail view, please click Home > New Items > More Items > Contact group to create a new contact group.

2. In the new opening Contact Group window, please name the new contact group in the Name box, and then click Contact Group > Save & Close. See screenshot:

3. Click to open the Sent Items folder, select all emails in the Sent Items folder, and then click Kutools > Add to Group. See screenshot:

4. In the opening Add Recipients to Contact Groups dialog box, please only check the recipients in the Recipients list box, check the new contact group you created above in the Contact Groups list box, and click the OK button.

Note: In the Add Recipients to Contact Groups dialog box, you can easily check all recipients only with (1) right clicking any emails and selecting Uncheck All from the context menu, next (2) right clicking any emails and selecting Check All Recipients from the context menu. See below screenshots:

5. Shift to the People (or Contacts) view, double click to open the new contact group, and then click Kutools > Count. See screenshot:

And then you will get the total number of all members in the new contact group as above screenshot shown. In other words, you have counted out the total number of all recipients in the Sent Items folder.

Kutools for Outlook: Supercharge Outlook with over 100 must-have tools. Test drive it for FREE for 60 days, no strings attached!   Read More...   Download Now!


Demo: Count the total number of all recipients you have sent emails to

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!


arrow blue right bubbleRelated Articles


Best Office Productivity Tools

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

📧 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 (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations