Can I get ALL contact's emails in CiviCRM reports?

Question

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.)

Answer 1

It's simple with Search Kit: see 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.

Answer 2

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;