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

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.

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:

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

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

---

Best Office Productivity Tools

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

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

📧 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 Pro: Batch 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