Monday, July 1, 2019

Display Duplicate Contacts Based on Email Address in a Contact Search

To get all contacts with same/ duplicate email addresses, below are the steps:

1. Navigate to Lists > Search > Saved Searches > New.
2. Under Criteria tab > Summary sub tab > enter the below in one line:
-- Summary type = Count
-- Field = Internal ID
-- Description = greater than 1

3. Under Results tab > Columns sub tab:
Internal ID (Summary type = Count)
- Formula (Text) (Summary type = Group, Formula = LOWER({email}))

Note:
If user wants the detailed results, user can add the following fields:

Edit the search > Results tab > Column sub tab:
- ID/ Name
- First Name
- Last Name
- Email

4.Click Save and Run.

No comments:

Post a Comment