Answers.Body: <p>You can add an extra column to your spreadsheet called &quot;On Hold&quot; and assign it 1, another one called &quot;hold date&quot; and then (3 options below, choose 1):</p>
  <ol>
  <li>import your sheet (using eileen's csv import extension) as &quot;emails&quot;, with appropriate matching rules.</li>
  </ol>
  <p><a href="https://civicrm.org/extensions/api-csv-import-gui" rel="nofollow noreferrer">https://civicrm.org/extensions/api-csv-import-gui</a></p>
  <ol start="2">
  <li><p>If you're brave, you could upload your sheet as it's own table and do an sql &quot;Update&quot; on the civicrm_email table joining your new table via the email addresses.</p>
  </li>
  <li><p>You might be able to just import your sheet as a regular contact import with your strict matching rule, if your email addresses are unique (I'm not sure whether this would work, but it might be the easiest if it does - the part I'm not sure about is whether the mapping you get would expose the is-on-hold field and on-hold-date field).</p>
  </li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-06T00:48:33.653Z
Answers.Text: why not just import the emails (assuming unique), add to a Group, then bulk update their Comm Prefs, or does that last step not exist or not cover the OP
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-08T14:42:31.960Z
Answers.Text: Sounds like how it should work, but I'm not seeing a bulk action to put on hold, only to unhold. There might be an extension that provides that action.
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-05T16:52:12.320Z
Answers.LastActivityDate: 2021-02-05T20:18:30.843Z
Answers.LastEditDate: 2021-02-05T20:18:30.843Z
Answers.UserDisplayName: Alan Dixon
Body: <p>Bounce processing has not been working - but I do have a list of addresses that have been bounced. What I want to do is bulk update all those matching contacts and put their emails on hold.</p>
  <p>I cant see a way of doing that. Is there?</p>
  
Tags: <civimail><import>
Title: Is there a bulk method to put emails on hold?
ThreadText: # Is there a bulk method to put emails on hold?
  
  (Asked by: username_0 on 2021-02-05)
  
  Bounce processing has not been working - but I do have a list of addresses that have been bounced. What I want to do is bulk update all those matching contacts and put their emails on hold.
  
  I cant see a way of doing that. Is there?
  
  **Tags:** civimail, import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-02-05. Score: 2
  
  You can add an extra column to your spreadsheet called "On Hold" and assign it 1, another one called "hold date" and then (3 options below, choose 1):
  
  1. import your sheet (using eileen's csv import extension) as "emails", with appropriate matching rules.
  
  <https://civicrm.org/extensions/api-csv-import-gui>
  
  2. If you're brave, you could upload your sheet as it's own table and do an sql "Update" on the civicrm\_email table joining your new table via the email addresses.
  3. You might be able to just import your sheet as a regular contact import with your strict matching rule, if your email addresses are unique (I'm not sure whether this would work, but it might be the easiest if it does - the part I'm not sure about is whether the mapping you get would expose the is-on-hold field and on-hold-date field).
  
  > **Comments:**
  > **username_2**: why not just import the emails (assuming unique), add to a Group, then bulk update their Comm Prefs, or does that last step not exist or not cover the OP  
  > **username_1**: Sounds like how it should work, but I'm not seeing a bulk action to put on hold, only to unhold. There might be an extension that provides that action.  
  
  ---
  
  