CiviCRM Community Forums (archive)

Hello,

On a membership signup, in order to give people the chance to opt out our mailing list, I've included a profile with the field 'do not email'.. It appears like this:

"We will send you a weekly newsletter made up of upcoming events, notices and information. If you do not want to receive this, tick the box below:
[] Do not email newsletter   

However, if someone doesn't tick the [] Do not email box (because they want to receive our mail)  it enters a NULL value into the Do Not Email column on their record. This means that if I try to do a mailing to all members where "Do Not Email != 1" it will include those who've opted out *and* those with NULL in the dbse. (It's taken me a while to figure out this is why new signups weren't getting an email)

The only way round this I can see would be to have a preselected radio button, eg:

"We will send you a weekly newsletter made up of upcoming events, notices and information. If you do not want to receive this, select NO below:

• yes please send me email [] no email

But not sure how to switch the default output.. or perhaps there's a more elegant way to do what I'm doing.

thanks
Nic

Hi Nic,

I just found this same bug today!  I dug into it, and I created a patch:
http://issues.civicrm.org/jira/browse/CRM-12748

Note that the patch is against my outdated copy of Civi 4.4alpha - but it's only three lines to patch, so if you want to manually patch your own install, you can probably figure it out.  Hopefully, the core team will get this fix into 4.3.4, so you don't have to do this yourself if you don't want.

Jon