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 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. Click for 60-day free trial without limitation!

count emails per day

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 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. Click for 60-day free trial without limitation!

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:

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: Add more than 100 handy tools for Outlook, free to try with no limitation in 60 days. Read More      Free Trial 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


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.

Be the first to comment.