CiviCRM Community Forums (archive)

Hmmm, works great until I get to step 9.  Although 128 Recipients were selected, in step 9 I get "Total Recipients: 2".  Ideas?

This Smart Group contains the 128 contacts, for which, the original email bounced.

I’m not sure whether I follow your case, but it might be worthwhile to check whether these recipients’ email addresses aren’t on hold; if there was a bounce, they might very well be, and in such case CiviMail won’t send to them.

This was great, thank you. In case anyone else needs it, here's a handy piece of sql to reset all the on_hold emails which were set by a specific bounce type (in my case it was 6, or "type unknown").

update civicrm_email ce inner join civicrm_mailing_event_queue eq on ce.id = eq.email_id inner join civicrm_mailing_event_bounce eb on eq.id = eb.event_queue_id set ce.on_hold = 0, reset_date = NOW() where eb.bounce_type_id = 6;

I'm tempted to suggest that running this every week or so might be smart, assuming that your 'type unknown' means it might actually be a valid account that you probably don't want to be set on hold.

Holy cannolli - you guys are amazing! You just saved my bacon.

Great solution - brilliantly documented - thanks to all...