Sage CRM 2020 R1: Duplicate email detection

Sage CRM 2020 R1 introduced several important changes to enhance the integration with Mailchimp.  I wrote about one of these changes in a previous article "Enforcing unique email addresses, Mailchimp improvements and identity matching".

In this article, I want to consider the way in which duplicate emails can be detected in the system and how Sage CRM will behave if we attempt to send a group to Mailchimp that contains duplicated email addresses.

Sage CRM 2020 R1 had added a new screen called Duplicate Emails that lists all Company, Person, and Lead records that have the same email address.
To access the new screen, on the main menu, click Marketing | Duplicate Emails.

Note: This screen is available only when Mailchimp Integration is enabled. To access this screen, you must have rights to use Mailchimp campaigns.




This screen helps users identify records that potentially can cause errors if sent to Mailchimp in the same group.

A new Mailchimp Notification message

The next change that Sage CRM 2020 R1 has introduced is a notification that provides information about invalid and duplicated email addresses in a group sent to Mailchimp.  This also makes it easier to troubleshoot issues.

Users can click the number of invalid or duplicate emails in the notification to open the corresponding error group and correct the invalid email addresses or amend the duplicate email addresses to make them unique.

Below is a group of records that need loading into Sage CRM.  They will be added into a Territory called ‘Food & Beverage’. They contain some duplicate email addresses.


There are 20 people in the newly created group, and these are going to be sent across to Mailchimp.

In this example the communication with Mailchimp is successful. BUT… as you can see in the screenshot below


I’ve got a notification that tells me that Sage CRM has detected that the group contained Duplicates and will not be processed.  If I click the link ‘Duplicate emails’.


That link brings us to a new dynamic group that has been created that contains the records with the duplicate email addresses.  The group is called the same as my original group but with the suffix ‘_error’.  We can now navigate to records and correct them as we need.
Anonymous