Answers.Body: <p>Since this is a one time issue (now that you've resolved with MailChimp), <strong>I would use that CSV to 're-import' those intended recipients with an Unknown status</strong>. The CSV should have email address as a field, so you can use that to match up your contacts.  See <a href="http://book.civicrm.org/user/common-workflows/importing-data/" rel="nofollow">Importing Data</a> and <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Data" rel="nofollow">Importing Data - CiviCRM Wiki</a> for reference.</p>
  
  <p>When you import the contacts, use the Update or Fill option for "For Duplicate Contacts" option (and they should all match if your dedupe rule uses email address). <strong>In one of the last steps of the import, you can add them to a new group. Use that group as the recipients for your re-sent mailing.</strong></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-15T19:25:22.500Z
Answers.LastActivityDate: 2016-02-15T20:07:24.053Z
Answers.LastEditDate: 2016-02-15T20:07:24.053Z
Answers.UserDisplayName: Allen Hutchison
Body: <p>I have a mailing list with 788 recipients. When run, the hosting server choked at 520 records because of server limitations. When I run the sent/scheduled mailings report I can generate the delivery summary and can get a .csv of both the intended recipients and the successful deliveries. The list of "intended recipient" contacts has one of two entries in the Delivery Status field: Successful and Unknown.</p>
  
  <p>What I need to do is  filter the original recipients list for delivery status=Unknown, but that I can't find a method to accomplish that. </p>
  
  <p>I've solved the host resource limitations issue by using Mailchimp and the Joomla Mailchimp extension. Now I want to resend the email only to the 228 people the server never got to.  Is there any way? I have tried custom searches, filters, various reports, but no luck. </p>
  
  <p>Any help would be appreciated. 
  Thanks. </p>
  
Tags: <civimail>
Title: Filter Mailing List report for unsent mails
ThreadText: # Filter Mailing List report for unsent mails
  
  (Asked by: username_0 on 2016-02-15)
  
  I have a mailing list with 788 recipients. When run, the hosting server choked at 520 records because of server limitations. When I run the sent/scheduled mailings report I can generate the delivery summary and can get a .csv of both the intended recipients and the successful deliveries. The list of "intended recipient" contacts has one of two entries in the Delivery Status field: Successful and Unknown.
  
  What I need to do is filter the original recipients list for delivery status=Unknown, but that I can't find a method to accomplish that.
  
  I've solved the host resource limitations issue by using Mailchimp and the Joomla Mailchimp extension. Now I want to resend the email only to the 228 people the server never got to. Is there any way? I have tried custom searches, filters, various reports, but no luck.
  
  Any help would be appreciated.
  Thanks.
  
  **Tags:** civimail
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-02-15. Score: 1 | Accepted answer
  
  Since this is a one time issue (now that you've resolved with MailChimp), **I would use that CSV to 're-import' those intended recipients with an Unknown status**. The CSV should have email address as a field, so you can use that to match up your contacts. See [Importing Data](http://book.civicrm.org/user/common-workflows/importing-data/) and [Importing Data - CiviCRM Wiki](https://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Data) for reference.
  
  When you import the contacts, use the Update or Fill option for "For Duplicate Contacts" option (and they should all match if your dedupe rule uses email address). **In one of the last steps of the import, you can add them to a new group. Use that group as the recipients for your re-sent mailing.**
  
  
  ---
  
  