Answers.Body: <p>Yes, it is safe to update the email in civicrm to on-hold.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-01T14:49:00.453Z
Answers.Text: Oh, I think you misread my question. I want to mark around 1000 addresses as On Hold; I don't want to remove them from hold!
Answers.UserDisplayName: zip
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-01T14:53:13.560Z
Answers.Text: Ahh sorry, updated the answer
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-01T14:56:29.383Z
Answers.Text: Terrific, thanks!
Answers.UserDisplayName: zip
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-12-01T14:45:01.363Z
Answers.LastActivityDate: 2022-12-01T14:53:00.180Z
Answers.LastEditDate: 2022-12-01T14:53:00.180Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>We've just now started getting bounce reports for our outgoing email, and the number of them is alarmingly high. The majority of the responses is: &quot;The email account that you tried to reach does not exist&quot; so it is just that our contact list is very out of date.</p>
  <p>From a recent mailer, CiviCRM marked 200 as bounces but the external bounce report shows over a 1000. That is a <em>lot</em> to go through 1 by 1, so I was thinking of running a database query such as:</p>
  <pre><code>update civicrm_email SET on_hold = '1', hold_date = NOW() 
  where email in ( 
   [list of email addresses]
  )
  </code></pre>
  <p>Is this an ill-advised thing to do? Is the on_hold information tracked elsewhere also that might cause a conflict?</p>
  <p>Thanks!</p>
  
Tags: <civimail>
Title: Is it safe to mark contact emails as "on_hold" in bulk with a direct database query?
ThreadText: # Is it safe to mark contact emails as "on_hold" in bulk with a direct database query?
  
  (Asked by: username_0 on 2022-12-01)
  
  We've just now started getting bounce reports for our outgoing email, and the number of them is alarmingly high. The majority of the responses is: "The email account that you tried to reach does not exist" so it is just that our contact list is very out of date.
  
  From a recent mailer, CiviCRM marked 200 as bounces but the external bounce report shows over a 1000. That is a *lot* to go through 1 by 1, so I was thinking of running a database query such as:
  
  ```
  update civicrm_email SET on_hold = '1', hold_date = NOW() 
  where email in ( 
   [list of email addresses]
  )
  
  ```
  
  Is this an ill-advised thing to do? Is the on\_hold information tracked elsewhere also that might cause a conflict?
  
  Thanks!
  
  **Tags:** civimail
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-12-01. Score: 0 | Accepted answer
  
  Yes, it is safe to update the email in civicrm to on-hold.
  
  > **Comments:**
  > **username_0**: Oh, I think you misread my question. I want to mark around 1000 addresses as On Hold; I don't want to remove them from hold!  
  > **username_1**: Ahh sorry, updated the answer  
  > **username_0**: Terrific, thanks!  
  
  ---
  
  