Why are contacts not receiving emails when do not email not checked?

Question

I have a group of elected officials that I regularly email with updates. When I try to contact them, I get the error "Email will NOT be sent to 4 contacts - (no email address on file, or communication preferences specify DO NOT EMAIL, or contact is deceased)." However, when I search for contacts matching one or more of those flags + belong to the group I get no results. I figured out which four contacts it is, and there is an email on their profile, the email is not being held, the DO NOT EMAIL box is not checked, and the contact is not marked deceased. Is there something else I may be missing? It's pretty important to us to get our messaging to these officials as they hold serious sway over our operations.

This is occurring when viewing the group and clicking "send email to contacts," I have not checked the mass mailing tool.

I'm using civi 4.6.9 on Wordpress 4.1

Answer 1

You may have zombies. I use this term not because it's almost Halloween, but because imports can leave you with undead contacts, and this may be a variation of that.

Boolean (yes/no) fields in CiviCRM have the value 1 or 0, but it's possible in the database for the field to have a null value. When you create a contact manually, the Is Deceased, Do Not Mail, etc. fields are set to 0, but if you run an import with one of those fields and only mark the dead or no-mail people with 1s, the rest will have the value as null.

When viewing a contact, it will only display deceased or do not mail if those values are 1. When sending email, it will only send if those values are 0. Hence, you have this mysterious issue.

I suspect you may have imported elected officials, included Do Not Email, but neglected to fill the zeroes where it's okay to email. Xavier's solution should work: by editing and re-editing the field, you can reset the value. It gets tedious for a bunch of contacts, though.

In the database you can execute the following query to fix this:

UPDATE civicrm_contact SET do_not_email = 0 WHERE do_not_email IS NULL;

Repeat for is_deceased and any others like that you want. You can also find these contacts in the Search Builder and use Batch Update Via Profile on the results, using a profile with Do Not Email in it.

Answer 2

Can you try sending one of the for a single email from their contact record and see if you have the same error message? Just to be 100% sure you have identified one of the broken records.

Can you then edit (not the edit in place fancy version) the full everything on one page one, try to check the on hold and do not mail, check that the email they have is marked as primary+bulk mail (if they have several, try to change the primary one), save, and revert your change then save again

I know it's a bit "can you reboot your computer" type of answer, but sometimes (eg when modifying the contacts via my own custom code or via some extension) some of the underlying data behind the contact record got mingled (eg not having any email marked as primary), and edit and save via the contact record helps to put it in good shape again.

X+