Answers.Body: <p>Reasons that come to mind for bulk emails not being sent to certain contacts:</p>
  
  <ul>
  <li>Contacts with duplicate email address (only one contact will receive the email unless you uncheck the "Dedupe by email" option next to the Recipients box).</li>
  <li>Contact has no email address which is marked either Primary or Bulk-Mailings and is not marked On-Hold.</li>
  <li><p>Either of the following privacy settings: </p>
  
  <ul>
  <li>Do not email</li>
  <li>NO BULK EMAILS (User Opt Out)</li>
  </ul></li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-20T03:58:47.447Z
Answers.Text: Thanks for the reply.  I checked the options you mentioned, and none of those seem to be the reason.  I threw some screen shots on imgur here (http://imgur.com/a/yABKa).  This is one contact that is listed in the group I created, but doesn't get picked up when I create a mailing with that group.
Answers.UserDisplayName: tdk2fe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-20T04:06:29.120Z
Answers.Text: I'm actually wondering if this is related to perhaps a conflicting plugin and javascript?  I can't seem to test this workflow on the demo site (no way to send email) but we've had a few issues with Slider Revolution conflicting with some of the stuff on the Civi side.  Do you think this could be a possible culprit?
Answers.UserDisplayName: tdk2fe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-20T17:43:43.613Z
Answers.Text: I think it's unlikely that your slider or other unrelated plugins could cause this but, as I have no other ideas, you could try temporarily disabling them. Do you have any custom plugins that employ Civi hooks? 
  
  You should check the Civi log file for any related messages.
  
  I know you've compared the working and not-working contacts, but you might create some test contacts and try to determine the pattern.
  
  Finally, as a last resort, you could step through the code with a debugger.
  
  Perhaps someone else can suggest another possible cause for your problem.
Answers.UserDisplayName: BobS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-20T17:56:27.703Z
Answers.Text: FYI: The demo site https://civicrm.demo.civihosting.com/ allows to to create contacts & groups and compose (if not send) a mailing, so you can at least see how many contacts in the selected recipient group would receive the mailing.
  
  Also, in desperation, you could try clearing the Civi caches -- Administer | System Settings | Cleanup Caches and Update Paths.
Answers.UserDisplayName: BobS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-23T01:31:56.443Z
Answers.Text: Well, i've ruled out any plugins with webhooks into civi.  Currently i'm sifting through the Mysql general log to see if I can identify the queries used and replicate, hopefully to understand what the differences between the contacts are.
Answers.UserDisplayName: tdk2fe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-19T15:35:07.173Z
Answers.LastActivityDate: 2017-08-19T15:35:07.173Z
Answers.UserDisplayName: BobS
Answers.Body: <p>So it looks like this is related to NULL values in the "is_deceased" field in CiviCRM.  It looks like setting this value to 0 manually (using actual SQL) mitigated the issue.  However, I'm not sure how to prevent this in the future other than perhaps explicitly setting the is_deceased on all of our bulk imports in the future.</p>
  
  <p><strong>Update</strong> This appears to be the same issue encountered in this thread: <a href="https://civicrm.stackexchange.com/questions/5086/civimail-does-not-send-to-a-whole-group?rq=1">CiviMail Does Not Send To A Whole Group</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-27T05:41:38.160Z
Answers.Text: I just looked at my DB and "is_deceased" are all 0 or 1, not NULL (I'm running on Drupal but I doubt there should be any difference). I think you need to determine why that field is being set NULL in the first place. How are your contacts being created/updated? Are you importing from CSV? From Webforms? Something else?
Answers.UserDisplayName: BobS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-27T11:49:12.747Z
Answers.Text: Yeah, we took the bulk of our contacts from a CSV import from various sources (other signup forms, manual entry, etc).  Manual creation of them doesn't seem to cause this, so I suspect it's something on the import side from those other sources.
Answers.UserDisplayName: tdk2fe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-27T18:04:05.493Z
Answers.Text: I'm guessing you're using an import map that contains the "is_deceased" field, but the csv has blanks in that column.
Answers.UserDisplayName: BobS
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-26T18:39:47.153Z
Answers.LastActivityDate: 2017-08-27T11:50:38.243Z
Answers.LastEditDate: 2017-08-27T11:50:38.243Z
Answers.UserDisplayName: tdk2fe
Body: <p>Having an interesting issue here whereby if I create a group in Civi to email, the actual recipient list is much smaller than the total number of contacts with an email in that group.</p>
  
  <p>For a recent mailing, we had about 1766 contacts selected to email.  However, on the next screen, only 289 contacts are expected to receive the email.  I thought perhaps this was only an estimate, and scheduled the email.  Once it sent (successfully) it indeed only went to 289 contacts.  Just to clarify, it was 100% successful in sending, so it's not as if the system attempted to send to all of the contacts in the group but failed.</p>
  
  <p>I compared some members in the group that didn't get the email to members that did, thinking it might be a communication preference or something like that.  I couldn't find anything between the contacts that received the email that differed from those who didn't.</p>
  
  <p>I'm on Wordpress running Civi 4.7.21.</p>
  
Tags: <wordpress><civimail>
Title: Email Group Only Pulls subset of total emails
ThreadText: # Email Group Only Pulls subset of total emails
  
  (Asked by: username_0 on 2017-08-19)
  
  Having an interesting issue here whereby if I create a group in Civi to email, the actual recipient list is much smaller than the total number of contacts with an email in that group.
  
  For a recent mailing, we had about 1766 contacts selected to email. However, on the next screen, only 289 contacts are expected to receive the email. I thought perhaps this was only an estimate, and scheduled the email. Once it sent (successfully) it indeed only went to 289 contacts. Just to clarify, it was 100% successful in sending, so it's not as if the system attempted to send to all of the contacts in the group but failed.
  
  I compared some members in the group that didn't get the email to members that did, thinking it might be a communication preference or something like that. I couldn't find anything between the contacts that received the email that differed from those who didn't.
  
  I'm on Wordpress running Civi 4.7.21.
  
  **Tags:** wordpress, civimail
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-08-19. Score: 2
  
  Reasons that come to mind for bulk emails not being sent to certain contacts:
  
  * Contacts with duplicate email address (only one contact will receive the email unless you uncheck the "Dedupe by email" option next to the Recipients box).
  * Contact has no email address which is marked either Primary or Bulk-Mailings and is not marked On-Hold.
  * Either of the following privacy settings:
  
    + Do not email
    + NO BULK EMAILS (User Opt Out)
  
  > **Comments:**
  > **username_0**: Thanks for the reply.  I checked the options you mentioned, and none of those seem to be the reason.  I threw some screen shots on imgur here (http://imgur.com/a/yABKa).  This is one contact that is listed in the group I created, but doesn't get picked up when I create a mailing with that group.  
  > **username_0**: I'm actually wondering if this is related to perhaps a conflicting plugin and javascript?  I can't seem to test this workflow on the demo site (no way to send email) but we've had a few issues with Slider Revolution conflicting with some of the stuff on the Civi side.  Do you think this could be a possible culprit?  
  > **username_1**: I think it's unlikely that your slider or other unrelated plugins could cause this but, as I have no other ideas, you could try temporarily disabling them. Do you have any custom plugins that employ Civi hooks?   You should check the Civi log file for any related messages.  I know you've compared the working and not-working contacts, but you might create some test contacts and try to determine the pattern.  Finally, as a last resort, you could step through the code with a debugger.  Perhaps someone else can suggest another possible cause for your problem.  
  > **username_1**: FYI: The demo site https://civicrm.demo.civihosting.com/ allows to to create contacts & groups and compose (if not send) a mailing, so you can at least see how many contacts in the selected recipient group would receive the mailing.  Also, in desperation, you could try clearing the Civi caches -- Administer | System Settings | Cleanup Caches and Update Paths.  
  > **username_0**: Well, i've ruled out any plugins with webhooks into civi.  Currently i'm sifting through the Mysql general log to see if I can identify the queries used and replicate, hopefully to understand what the differences between the contacts are.  
  
  ---
  
  ### Answer by username_0 on 2017-08-26. Score: 0
  
  So it looks like this is related to NULL values in the "is\_deceased" field in CiviCRM. It looks like setting this value to 0 manually (using actual SQL) mitigated the issue. However, I'm not sure how to prevent this in the future other than perhaps explicitly setting the is\_deceased on all of our bulk imports in the future.
  
  **Update** This appears to be the same issue encountered in this thread: [CiviMail Does Not Send To A Whole Group](https://civicrm.stackexchange.com/questions/5086/civimail-does-not-send-to-a-whole-group?rq=1)
  
  > **Comments:**
  > **username_1**: I just looked at my DB and "is_deceased" are all 0 or 1, not NULL (I'm running on Drupal but I doubt there should be any difference). I think you need to determine why that field is being set NULL in the first place. How are your contacts being created/updated? Are you importing from CSV? From Webforms? Something else?  
  > **username_0**: Yeah, we took the bulk of our contacts from a CSV import from various sources (other signup forms, manual entry, etc).  Manual creation of them doesn't seem to cause this, so I suspect it's something on the import side from those other sources.  
  > **username_1**: I'm guessing you're using an import map that contains the "is_deceased" field, but the csv has blanks in that column.  
  
  ---
  
  