Answers.Body: <p>The API CSV import extension using the email entity has a way to import these.<a href="https://i.sstatic.net/XmvXg.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/XmvXg.png" alt="enter image description here"></a></p>
  
  <p>It looks like you can match on external ID.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-13T17:51:11.197Z
Answers.Text: So I have the CiviCRM contact ID - I want to mark an email as use for bulk mail - so I have selected Email Contact (Match using external identifier) and chose the column with the Contact ID - and I chose the column with the email to match with Use for bulk mail.  Then I get the error: Missing required field(s) : email
Answers.UserDisplayName: themak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-13T18:11:51.297Z
Answers.Text: I do not know why contact ID field is not available. The actual email should use 'email' field and then it is '1" value for 'Use for bulk email'.
Answers.UserDisplayName: Andy Burns
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-13T16:47:22.930Z
Answers.LastActivityDate: 2019-02-13T16:47:22.930Z
Answers.UserDisplayName: Andy Burns
Body: <p>So - here is the deal - we have an excel sheet with hundreds of contacts - with which email they would like set as bulk mail. While doing an import, I see no option to indicate bulk mail preferences - any suggestions?</p>
  
  <p>Civi 5.10, Drupal 7</p>
  
Tags: <email><import><data-import>
Title: Mass update / import bulk email preferences?
ThreadText: # Mass update / import bulk email preferences?
  
  (Asked by: username_0 on 2019-02-13)
  
  So - here is the deal - we have an excel sheet with hundreds of contacts - with which email they would like set as bulk mail. While doing an import, I see no option to indicate bulk mail preferences - any suggestions?
  
  Civi 5.10, Drupal 7
  
  **Tags:** email, import, data-import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-02-13. Score: 2
  
  The API CSV import extension using the email entity has a way to import these.[![enter image description here](https://i.sstatic.net/XmvXg.png)](https://i.sstatic.net/XmvXg.png)
  
  It looks like you can match on external ID.
  
  > **Comments:**
  > **username_0**: So I have the CiviCRM contact ID - I want to mark an email as use for bulk mail - so I have selected Email Contact (Match using external identifier) and chose the column with the Contact ID - and I chose the column with the email to match with Use for bulk mail.  Then I get the error: Missing required field(s) : email  
  > **username_1**: I do not know why contact ID field is not available. The actual email should use 'email' field and then it is '1" value for 'Use for bulk email'.  
  
  ---
  
  