Body: <p>I'm trying to send a mass emailing to a group I have set up.  When I put the group into the mailing, it shows that there are no recipients even though there should be hundreds.  I have found that if I tick the &quot;Bulk mailings?&quot; option next to an individual's email address, they're then part of the recipients.  Is there a way to check this box for everyone, or is there some other thing I can do?</p>
  <p>I did try &quot;update civicrm_email set is_bulkmail=1&quot; and although all the records were changed, they're still not included in the mailings.  Now I find that if I &quot;edit&quot; a record, do nothing, then &quot;save&quot;, they're suddenly included in the mailing.</p>
  <p>Thanks,
  Richard</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-05T11:00:35.010Z
Comments.Text: Do you have `is_primary` set on any of the emails in civicrm_email table? Specifically for the recipients?
Comments.UserDisplayName: jitendra - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-06T18:06:30.607Z
Comments.Text: If you're going to make bulk changes like that, you're better doing it with the API than direct SQL.  There are dependencies between fields that API updates will take care of and avoid some issues like this.  (Not saying this was caused by doing SQL updates, but possible.)
Comments.UserDisplayName: Aidan
Tags: <civimail>
Title: Bulk mailing to a group has no recipients
ThreadText: # Bulk mailing to a group has no recipients
  
  (Asked by: username_0 on 2020-08-03)
  
  I'm trying to send a mass emailing to a group I have set up. When I put the group into the mailing, it shows that there are no recipients even though there should be hundreds. I have found that if I tick the "Bulk mailings?" option next to an individual's email address, they're then part of the recipients. Is there a way to check this box for everyone, or is there some other thing I can do?
  
  I did try "update civicrm\_email set is\_bulkmail=1" and although all the records were changed, they're still not included in the mailings. Now I find that if I "edit" a record, do nothing, then "save", they're suddenly included in the mailing.
  
  Thanks,
  Richard
  
  **Tags:** civimail
  
  > **Comments:**
  > **username_1**: Do you have `is_primary` set on any of the emails in civicrm_email table? Specifically for the recipients?  
  > **username_2**: If you're going to make bulk changes like that, you're better doing it with the API than direct SQL.  There are dependencies between fields that API updates will take care of and avoid some issues like this.  (Not saying this was caused by doing SQL updates, but possible.)  
  
  ---
  
  ## 0 answers
  
  