Skip to main content

How to remove duplicate recipients from To/Cc/Bcc field in Outlook?

Author: Kelly Last Modified: 2020-05-26

Let’s say you need to send an email to several departments in your organization via Microsoft Outlook, you may add contact groups into the To filed. Then duplicate recipients occur because some emails exist in several contact groups simultaneously. How to avoid sending this email to the same recipients twice or more? In this article, we will show you some ways to remove duplicate recipients from To/Cc/Bcc field in Microsoft Outlook.

Remove duplicate recipients from To/Cc/Bcc field with building a temporary contact group
Remove duplicate recipients from To/Cc/Bcc field with the help of Excel
One click to remove duplicate recipients from To/Cc/Bcc field


Remove duplicate recipients with a temporary contact group

This method will guide you to copy all recipients’ email addresses, build an new temporary contact group, and then add this contact group into the To field in your composing email.

1: In you composing email, copy all email addresses from the To field.

2: Then go to the mail interface of Microsoft Outlook, and create a new contact group:

  1. In Outlook 2010 and higher version, Please click the New Items > More Items > Contact group on the Home tab.
  2. In Outlook 2007, please click the File > New > Distribution List.

3: In the Contact group window, please click the Add Members > From Address Book on the Contact Group tab.

If you are using Outlook 2007, please click the Select Members button on the Distribution List tab.

4: In the popping up Select Members: Global Address List dialog box, please paste the email addresses you copied in 1 into the Members box, and click the OK button. See screen shot:

Note: After clicking OK button, the unique members are added to the Contact Group, and the duplicates are filtered automatically.
5: Then in the Contact Group window, enter a name for this contact group in the Name: filed, and then click the Save & Close button.
In our case, we name the new contact group as Temporary--group 1. See screen shot:

6: Go back to the Message window, delete the existing recipients from the To files, and enter the name of new contact group into it.

Note: When you enter the beginning letters of the contact group’ name in the To filed in Outlook 2010 and 2013, the AutoComplete list will come out automatically. Just click the contact group’s name from the drop down list to enter it.

7: This step is optional. The contact group collapses in the To field by default. To expand the contact group, please click the before it, and then click the OK button in the popping up Expand List dialog box. See screen shot:

Then all duplicate email addresses are removed from the To field, and leave with only unique recipients. You can remove duplicate recipients from the Cc field and Bcc filed with the same way.


One click to remove all duplicate names from To/Cc/Bcc fields in Outlook:

Kutools for Outlook's Remove Duplicate Names utility can help you easily remove all duplicate names from To/Cc/Bcc fields in Outlook when composing email. see following screenshot: Download and try it now! (30-day free trail)


Remove duplicate recipients with the help of Excel

This method will help you remove duplicate recipients in Microsoft Excel, and then copy and paste unique recipients into the composing email message.
1: In you composing email, copy all email addresses from the To field.

2: Open Microsoft Excel, select a blank cell in a blank sheet, for example the Cell A1, and then paste the email addresses into it.

3: Keep selecting the cell, and click the Text to Columns button on the Data tab.

4: In the Convert Text to Columns Wizard – 1 of 3 dialog box, check the Delimited option, and click the Next.

5: In the Convert Text to Columns Wizard – 2 of 3 dialog box, please check the Semicolon, and then click the Finish button.

6: Copy the Row 1, right click a blank cell, for example the Cell A2, and click the Transpose button in the Paste Options: group. See screen shot:

Then the email addresses are listing in the Column A.

7: Select the Column A, and click the Remove Duplicates button on the Data tab.

8: In the popping up Remove Duplicates dialog box, please click the OK button.

8: Then a warning dialog box comes out and tells you how many duplicate emails have been found and removed. Just click the OK button.

9: Copy these unique email addresses, and then paste them into the To field in the composing email message in Microsoft Outlook.


One click to remove duplicate recipients from To/Cc/Bcc field

With the Remove Duplicate Names utility of Kutools for Outlook, you can remove all duplicate recipients from To/Cc/Bcc field with just one click. Please do as follows.

In the composing email you need to remove duplicate recipients, please click Kutools > Duplicate Names. See screenshot:

doc delete recipients

Then all duplicate recipients are removed from To/Cc/Bcc fields immediately.

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


One click to remove duplicate recipients from To/Cc/Bcc field


Best Office Productivity Tools

Breaking News: Kutools for Outlook Launches Free Version!

Experience the all-new Kutools for Outlook FREE version with 70+ incredible features, yours to use FOREVER! Click to download now!

🤖 Kutools AI : Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 Email Automation: Auto Reply (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: 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   /  Remind you when important emails come  /  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 ...

Instantly unlock Kutools for Outlook with a single click—permanently free. Don't wait, download now and boost your efficiency!

kutools for outlook features1 kutools for outlook features2
 

 

 

Comments (11)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
This is really really real and i'm very proud of this web, thanks so much for this useful info
This comment was minimized by the moderator on the site
Great article, thank you!
This comment was minimized by the moderator on the site
I don't have kutools but this article was great and helped
This comment was minimized by the moderator on the site
I cannot copy the address from the "To" field, only the name of the recipients...
This comment was minimized by the moderator on the site
how to remove duplicate email address from the "FROM FIELD "
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations