2

I'd like to create such a group so that I can contact them to identify which of their multiple email addresses they want to have as their primary one.

2 Answers 2

4

This is an old question but has a new solution using Search Kit:

See here

enter image description here

From the search, you could create a smart group.

The original solution looks for multiple addresses even if they are the same. To get the same results, untick 'distinct'. For the purpose described in the question, it is probably more useful to look at the number of distinct addresses.

3

Here's a hack that only works if you're not using the "Do not SMS" field for contacts, if you do, find a different one.

  1. Use that field as a temporary flag to identify contacts in the group, using sql like this:

    UPDATE civicrm_contact set do_not_sms = 1 where id in (SELECT contact_id FROM civicrm_email group by contact_id having count(id) > 1)

  2. Use that field via a search to select all the multi-email contacts.

  3. Put 'em in a group.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.