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.


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.