Bounce processing has not been working - but I do have a list of addresses that have been bounced. What I want to do is bulk update all those matching contacts and put their emails on hold.
I cant see a way of doing that. Is there?
CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.Sign up to join this community
You can add an extra column to your spreadsheet called "On Hold" and assign it 1, another one called "hold date" and then (3 options below, choose 1):
If you're brave, you could upload your sheet as it's own table and do an sql "Update" on the civicrm_email table joining your new table via the email addresses.
You might be able to just import your sheet as a regular contact import with your strict matching rule, if your email addresses are unique (I'm not sure whether this would work, but it might be the easiest if it does - the part I'm not sure about is whether the mapping you get would expose the is-on-hold field and on-hold-date field).