Answers.Body: <p>If you need to do some sort of 'when on earth did all our records get put 'on hold' you can do a sequel search on the 'hold_date field eg <pre>SELECT
    Year(<code>hold_date</code>),
    Month(<code>hold_date</code>),
    Count(*) As Total_Rows,
    Count(<code>id</code>) As Rows_With_Attribute
  FROM civicrm_email
  GROUP BY Year(<code>hold_date</code>), Month(<code>hold_date</code>)</pre></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-10T03:25:04.913Z
Answers.LastActivityDate: 2017-11-10T03:25:04.913Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You can perfectly get the result you want navigating to <strong>Search - Advanced Search</strong> and expand the <strong>Mailings</strong> section, from there you can search for bounced emails or opt-out request specifying a date range.  </p>
  
  <p>If you cannot see the Mailings section navigate to <strong>Administer - Customize Data and Screens - Display Preferences</strong> and make sure you have Mailing ticked under <strong>Contact Search</strong></p>
  
  <p>You can do the same from <strong>Search - Search Builder</strong> selecting Contact as record type and On Hold or No Bulk emails(User Opt Out) as the field.</p>
  
  <p>You can also bulk <strong>Unhold Emails</strong> from the action menu in the search result, selecting the contacts you think they shouldn't be on hold.</p>
  
  <p>Hope that helps.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-30T21:00:31.890Z
Answers.Text: Hi Andrei - thanks for the comprehensive answer.  That was exactly what I was looking for. My Mailing section wasn't visible and as soon as I fixed that I found what I needed.  Thank you.
Answers.UserDisplayName: Davy Ivins
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-30T14:14:22.653Z
Answers.LastActivityDate: 2016-03-30T14:14:22.653Z
Answers.UserDisplayName: Andrei
Body: <p>We experienced a severe network problem across many ISP's this week that resulted in a bunch of email non deliveries. I now have many email addresses marked as on hold, I think because of the unusual network problems. I want to unhold these addresses, but do not want to unhold emails where addressees opted out. </p>
  
  <p>Is there a way to search for emails that are on hold because of bounces, and not because they opted out. (alternatively can I search for emails that are on hold because of an opt out, and not because of bounce processing).</p>
  
  <p>Thanks
  Davy</p>
  
Tags: <civimail>
Title: How to search for emails "on hold opt out" and not "on hold bounce"
ThreadText: # How to search for emails "on hold opt out" and not "on hold bounce"
  
  (Asked by: username_0 on 2016-03-30)
  
  We experienced a severe network problem across many ISP's this week that resulted in a bunch of email non deliveries. I now have many email addresses marked as on hold, I think because of the unusual network problems. I want to unhold these addresses, but do not want to unhold emails where addressees opted out.
  
  Is there a way to search for emails that are on hold because of bounces, and not because they opted out. (alternatively can I search for emails that are on hold because of an opt out, and not because of bounce processing).
  
  Thanks
  username_0
  
  **Tags:** civimail
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-03-30. Score: 5 | Accepted answer
  
  You can perfectly get the result you want navigating to **Search - Advanced Search** and expand the **Mailings** section, from there you can search for bounced emails or opt-out request specifying a date range.
  
  If you cannot see the Mailings section navigate to **Administer - Customize Data and Screens - Display Preferences** and make sure you have Mailing ticked under **Contact Search**
  
  You can do the same from **Search - Search Builder** selecting Contact as record type and On Hold or No Bulk emails(User Opt Out) as the field.
  
  You can also bulk **Unhold Emails** from the action menu in the search result, selecting the contacts you think they shouldn't be on hold.
  
  Hope that helps.
  
  > **Comments:**
  > **username_0**: Hi username_2 - thanks for the comprehensive answer.  That was exactly what I was looking for. My Mailing section wasn't visible and as soon as I fixed that I found what I needed.  Thank you.  
  
  ---
  
  ### Answer by username_1 on 2017-11-10. Score: 0
  
  If you need to do some sort of 'when on earth did all our records get put 'on hold' you can do a sequel search on the 'hold\_date field eg
  
  ```
  SELECT
    Year(hold_date),
    Month(hold_date),
    Count(*) As Total_Rows,
    Count(id) As Rows_With_Attribute
  FROM civicrm_email
  GROUP BY Year(hold_date), Month(hold_date)
  ```
  
  
  ---
  
  