Answers.Body: <p>This is definitely a blind spot in CiviCRM!  I don't think there's anything except a very hard way:  Write SQL to get the contact IDs, then import those IDs, assigning them to a new group.</p>
  
  <p>To get the IDs of EVERYONE with a PCP, here's the SQL:</p>
  
  <p><code>SELECT contact_id from civicrm_pcp;</code></p>
  
  <p>If you want to get the PCPs associated with a particular contribution page, and that contribution page's ID is 12, here's the SQL:</p>
  
  <p><code>SELECT contact_id from civicrm_pcp cp JOIN civicrm_pcp_block cpb on cp.pcp_block_id = cpb.id WHERE cpb.entity_id = 12 AND cpb.entity_table = 'contribute';</code></p>
  
  <p>If it's an event page, change <code>contribute</code> to <code>event</code>.</p>
  
  <p>Export that as CSV (this is trivial in PHPMyAdmin, for command line you can look up syntax).  Import the list of ONLY contact IDs to CiviCRM through <strong>Contacts menu » Import Contacts</strong>. On screen 4 of 4 of the import, you can specify a (new or existing) group to add your contacts to.  Once it's imported, you can mass mail the contacts.</p>
  
  <p>Sorry it's such a hassle!  Hopefully an organization invested in PCPs will step up and fund a better solution.  If nothing else, a custom search would be easy to write.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-30T03:24:01.707Z
Answers.LastActivityDate: 2016-08-30T03:24:01.707Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I have a contribution page that has pcp enabled. I want to send out a mass email to all the pcp owners. I can display a list of all the pages with owners, but I can't do any actions on them. Is there an easy (or even a hard) way to do this?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-30T20:23:18.037Z
Comments.Text: I think PCP stands for "Personal Campaign Page".
Comments.UserDisplayName: peterb
Tags: <email><contributions><pcp>
Title: How can I send mass email to all contribution page pcp owners?
ThreadText: # How can I send mass email to all contribution page pcp owners?
  
  (Asked by: username_0 on 2016-07-30)
  
  I have a contribution page that has pcp enabled. I want to send out a mass email to all the pcp owners. I can display a list of all the pages with owners, but I can't do any actions on them. Is there an easy (or even a hard) way to do this?
  
  **Tags:** email, contributions, pcp
  
  > **Comments:**
  > **username_1**: I think PCP stands for "Personal Campaign Page".  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-08-30. Score: 2
  
  This is definitely a blind spot in CiviCRM! I don't think there's anything except a very hard way: Write SQL to get the contact IDs, then import those IDs, assigning them to a new group.
  
  To get the IDs of EVERYONE with a PCP, here's the SQL:
  
  `SELECT contact_id from civicrm_pcp;`
  
  If you want to get the PCPs associated with a particular contribution page, and that contribution page's ID is 12, here's the SQL:
  
  `SELECT contact_id from civicrm_pcp cp JOIN civicrm_pcp_block cpb on cp.pcp_block_id = cpb.id WHERE cpb.entity_id = 12 AND cpb.entity_table = 'contribute';`
  
  If it's an event page, change `contribute` to `event`.
  
  Export that as CSV (this is trivial in PHPMyAdmin, for command line you can look up syntax). Import the list of ONLY contact IDs to CiviCRM through **Contacts menu » Import Contacts**. On screen 4 of 4 of the import, you can specify a (new or existing) group to add your contacts to. Once it's imported, you can mass mail the contacts.
  
  Sorry it's such a hassle! Hopefully an organization invested in PCPs will step up and fund a better solution. If nothing else, a custom search would be easy to write.
  
  
  ---
  
  