Answers.Body: <p>It's simple with Search Kit: see <a href="https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22,%22GROUP_CONCAT(DISTINCT%20Contact_Email_contact_id_01.email)%20AS%20GROUP_CONCAT_Contact_Email_contact_id_01_email%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22id%22%5D,%22join%22:%5B%5B%22Email%20AS%20Contact_Email_contact_id_01%22,%22LEFT%22,%5B%22id%22,%22%3D%22,%22Contact_Email_contact_id_01.contact_id%22%5D%5D%5D,%22having%22:%5B%5D%7D" rel="nofollow noreferrer">here</a></p>
  <p><a href="https://i.sstatic.net/0FZSQ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/0FZSQ.png" alt="enter image description here" /></a></p>
  <p>You say: &quot;There is with Search Kit, but an option with Reports would be much better for automatic processing&quot; - 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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-24T20:35:54.423Z
Answers.Text: Perhaps @Aivars is referring to the feature that allows reports to be emailed out on a regular basis.
Answers.UserDisplayName: Noah Miller
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-25T11:45:30.703Z
Answers.Text: @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.
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-26T08:51:28.367Z
Answers.Text: I've noted that here: https://lab.civicrm.org/dev/core/-/issues/3478
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-23T09:31:32.900Z
Answers.LastActivityDate: 2022-05-23T09:31:32.900Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>You could use <a href="https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks" rel="nofollow noreferrer">SQL Tasks</a> 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:</p>
  <pre><code>SELECT display_name, email 
  FROM civicrm_contact cc 
  JOIN civicrm_email ce ON cc.id = ce.contact_id;
  </code></pre>
  <p>OR</p>
  <pre><code>SELECT display_name, GROUP_CONCAT(email)
  FROM civicrm_contact cc 
  JOIN civicrm_email ce ON cc.id = ce.contact_id
  GROUP BY display_name;
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-06-06T13:48:18.067Z
Answers.Text: Interesting. I will check it out.
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-26T16:08:38.173Z
Answers.LastActivityDate: 2022-05-26T16:08:38.173Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>By default, CiviCRM Reports include only contact's <strong>Primary email</strong>.</p>
  <p>How can I create a report which includes <strong>all contact's emails</strong>?</p>
  <p><strong>Alternatively</strong>, 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.)</p>
  
Tags: <civireport><searchkit>
Title: Can I get ALL contact's emails in CiviCRM reports?
ThreadText: # Can I get ALL contact's emails in CiviCRM reports?
  
  (Asked by: username_0 on 2022-05-20)
  
  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.)
  
  **Tags:** civireport, searchkit
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2022-05-23. Score: 3
  
  It's simple with Search Kit: see [here](https://dmaster.demo.civicrm.org/civicrm/admin/search#/create/Contact?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22display_name%22,%22GROUP_CONCAT(DISTINCT%20Contact_Email_contact_id_01.email)%20AS%20GROUP_CONCAT_Contact_Email_contact_id_01_email%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5D,%22groupBy%22:%5B%22id%22%5D,%22join%22:%5B%5B%22Email%20AS%20Contact_Email_contact_id_01%22,%22LEFT%22,%5B%22id%22,%22%3D%22,%22Contact_Email_contact_id_01.contact_id%22%5D%5D%5D,%22having%22:%5B%5D%7D)
  
  [![enter image description here](https://i.sstatic.net/0FZSQ.png)](https://i.sstatic.net/0FZSQ.png)
  
  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.
  
  > **Comments:**
  > **username_2**: Perhaps @username_0 is referring to the feature that allows reports to be emailed out on a regular basis.  
  > **username_0**: @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.  
  > **username_1**: I've noted that here: https://lab.civicrm.org/dev/core/-/issues/3478  
  
  ---
  
  ### Answer by username_3 on 2022-05-26. Score: 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;
  
  > **Comments:**
  > **username_0**: Interesting. I will check it out.  
  
  ---
  
  