2

By default, CiviCRM Reports include only contact's Primary email.

How can I create a report which includes all contact's emails?

Alternatively, is there a way I can export ALL users with ALL emails? (There is with Search Kit, but an option with Reports would be much better for automatic processing.)

2 Answers 2

3

It's simple with Search Kit: see here

enter image description here

You say: "There is with Search Kit, but an option with Reports would be much better for automatic processing" - what 'automatic processing' are you referring to? Search Kit surpasses Reports in many ways and will eventually replace them so far as I know so it's useful to understand what people are doing with reports that can't be done, or is harder, with Search Kit.

3
  • 1
    Perhaps @Aivars is referring to the feature that allows reports to be emailed out on a regular basis. May 24, 2022 at 20:35
  • @NoahMiller that's absolutely right, we are emailing reports automatically. From there, the data is automatically inserted and regularly updated in Google Spreadsheets, making it available for further processing.
    – Aivars
    May 25, 2022 at 11:45
  • 1
    I've noted that here: lab.civicrm.org/dev/core/-/issues/3478
    – Aidan
    May 26, 2022 at 8:51
0

You could use SQL Tasks to generate the report you're looking for, which can automatically deliver a CSV to you via email. Depending on the format you're looking for, you'll want something like:

SELECT display_name, email 
FROM civicrm_contact cc 
JOIN civicrm_email ce ON cc.id = ce.contact_id;

OR

SELECT display_name, GROUP_CONCAT(email)
FROM civicrm_contact cc 
JOIN civicrm_email ce ON cc.id = ce.contact_id
GROUP BY display_name;
1
  • Interesting. I will check it out.
    – Aivars
    Jun 6, 2022 at 13:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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