Answers.Body: <p>You can do this in api explorer, e.g. https://site/civicrm/api4. (Note to set Limit to 0)</p>
  <p>But you might want to think twice about doing this since if the bouncing email gets added again and you send it an email again (not via mandrill) it might eventually hurt your email reputation.</p>
  <p>(Thanks to Aidan for the simplification.)</p>
  <p><a href="https://i.sstatic.net/UIKQJ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/UIKQJ.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-17T19:03:15.010Z
Answers.Text: Just wondering why you did this with a chain instead of a simple Email.delete with a 'where' clause: `civicrm_api4('Email', 'delete', [ 'where' => [ ['on_hold:name', '=', 'On Hold Bounce'] ] ]);` (Habit from api3??)
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-17T19:17:01.050Z
Answers.Text: Oh ha. I think it was because I started out trying to just get the list of on hold because I can never remember which of those things are contact-level properties, and yeah api3 blurs them a bit. And then once I had it for whatever reason I didn't think to just change the action.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-16T15:48:30.383Z
Answers.LastActivityDate: 2021-11-17T19:17:34.817Z
Answers.LastEditDate: 2021-11-17T19:17:34.817Z
Answers.UserDisplayName: Demerit
Body: <p>Scuse if I am missing something obvious:</p>
  <p>We send all our emails out through Mandrill (aka Mailchimp transactional emails) and it places emails On Hold if they hard or soft bounce.</p>
  <p>We want to delete all the emails from our list that are hard bounces. How might we do this?</p>
  <p>We could use our Mandrill report to place all the contacts with emails that are hard-bouncing into a group. But that won't help us know which of their (potentially) multiple emails to delete. We'll only know which contacts have 'an email' that is hard bouncing.</p>
  <p>Anyone got any methods for deleting the hard bouncing emails, but only those emails?</p>
  <p>Thanks!</p>
  
Tags: <civimail><mandrill>
Title: mass deleting on hold emails
ThreadText: # mass deleting on hold emails
  
  (Asked by: username_0 on 2021-11-16)
  
  Scuse if I am missing something obvious:
  
  We send all our emails out through Mandrill (aka Mailchimp transactional emails) and it places emails On Hold if they hard or soft bounce.
  
  We want to delete all the emails from our list that are hard bounces. How might we do this?
  
  We could use our Mandrill report to place all the contacts with emails that are hard-bouncing into a group. But that won't help us know which of their (potentially) multiple emails to delete. We'll only know which contacts have 'an email' that is hard bouncing.
  
  Anyone got any methods for deleting the hard bouncing emails, but only those emails?
  
  Thanks!
  
  **Tags:** civimail, mandrill
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-11-16. Score: 1
  
  You can do this in api explorer, e.g. https://site/civicrm/api4. (Note to set Limit to 0)
  
  But you might want to think twice about doing this since if the bouncing email gets added again and you send it an email again (not via mandrill) it might eventually hurt your email reputation.
  
  (Thanks to username_2 for the simplification.)
  
  [![enter image description here](https://i.sstatic.net/UIKQJ.png)](https://i.sstatic.net/UIKQJ.png)
  
  > **Comments:**
  > **username_2**: Just wondering why you did this with a chain instead of a simple Email.delete with a 'where' clause: `civicrm_api4('Email', 'delete', [ 'where' => [ ['on_hold:name', '=', 'On Hold Bounce'] ] ]);` (Habit from api3??)  
  > **username_1**: Oh ha. I think it was because I started out trying to just get the list of on hold because I can never remember which of those things are contact-level properties, and yeah api3 blurs them a bit. And then once I had it for whatever reason I didn't think to just change the action.  
  
  ---
  
  