Change everyone to recieve newsletter

[crosswinds]

Hello!

 

Is there any way to change so that everyone in the database recieves the newsletters?

[♥14steve14]

You can do it using phpmyadmin and change the database field. You can also have the tick box filled in on the create account page.

 

Check the legalities first as in most countries you have to allow customers to opt in to receiving newsletters, and not to opt out.

[crosswinds]

^{Thank you for your reply!}

 

 

^{Best regards}

[crosswinds]

You can do it using phpmyadmin and change the database field. You can also have the tick box filled in on the create account page.

 

Check the legalities first as in most countries you have to allow customers to opt in to receiving newsletters, and not to opt out.

 

Hello again, i had a look in phpmyadmin, but im unfamilliar on how to do this.

 

I can edit one and one, but i dont know how to edit everyone in a batch?

[Guest]

@@crosswinds

 

Maybe you missed Steve's warning. You can be held LIABLE if you send unsolicited newsletters to customers who HAVE NOT OPTED TO RECEIVE THEM.

 

Also, if you are unfamiliar with PHPMYDMIN, then I wouldn't suggest messing with the database.

 

 

 

Chris

[♥14steve14]

Thanks chris. That is the reason why I didnt post any code changes or add any further explanations. I do not want to be liable either.

[npn2531]

No one is going to do anything, ever, should someone complain to the authorities (and who would that be, 911?, the FBI? your webhost?) that they typed their email into your website and then they received an email from you. Especially if you have a 'unsubscribe' link in the email, and actually unsubscribed them.

[Guest]

@@npn2531

 

Actually, you can report spam to all of the major Anti-virus companies and they will add that person to the SPAM list which bans the users email address. I get spam all the time, and report every sender to Symantec. It works, the spam stops.

 

 

 

 

Chris

[npn2531]

Cool, I am going to report my competitor's email addresses to Symantec, that'll stop 'em! Heck, I'll add my last employers email address as well, I can't stand him.

 

Snark aside, if you type in your email address into a website, and subsequently get an email from that company, and then when you ask, or click an link to be taken off that list, and you are taken off, Symantec is not going to list that company as spam.

[crosswinds]

Hello!

 

And sorry for my late reply.

 

Firstly, i do understand your concerns. But in Sweden, the rules for this is different.

Also. This is not for marketing reasons, but for general information to all my customers.

 

 

Thank you npn2531 for your more realistic input on this.

[npn2531]

To change every customer to receive the newsletter open up phpMyAdmin in your webhost control panel. Click your database open, then click on the SQL tab at the top. A dialog window will open. Paste in this:

UPDATE  `customers` SET  `customers_newsletter` =  '0'

 

and click go. This will change everybody to '0'. It may be you need to change everyone to 1 or 2, I just can't remember if 0, 1 or 2 is designation newsletter uses to tag for inclusion on the mailing list.

[crosswinds]

To change every customer to receive the newsletter open up phpMyAdmin in your webhost control panel. Click your database open, then click on the SQL tab at the top. A dialog window will open. Paste in this:

UPDATE  `customers` SET  `customers_newsletter` =  '0'

 

and click go. This will change everybody to '0'. It may be you need to change everyone to 1 or 2, I just can't remember if 0, 1 or 2 is designation newsletter uses to tag for inclusion on the mailing list.

 

 

Thank you for your help!

[npn2531]

Please note in the above that in the cutting and pasting the ' may need retyping, as there seem to be several versions of ' .

[MrPhil]

Please note in the above that in the cutting and pasting the ' may need retyping, as there seem to be several versions of ' .

It looks OK from here, although it is a good point that there are two different kinds of ticks used in the post: backticks ` around table and field names, and single quotes ' around field values. When cutting and pasting from a Word or Outlook document, you have to be careful about Microsoft "Smart Quotes" turning ' into other forms of "typographically pleasing" opening and closing curved single quotes that don't work in SQL.

[MrPhil]

But in Sweden, the rules for this is different.

As Sweden is E.U., I would be surprised if they were operating under weaker privacy rules than in the U.S. Anyway, if know what your country's law is, and you feel that you're in compliance with it, you've taken responsibility for any problems.

 

Also. This is not for marketing reasons, but for general information to all my customers.

Depending on how the law is written, they may or may not make an exception for "general information" broadcasts (versus "marketing"). Certainly, informing customers of security problems such as a credit card processor breach would override any customer's failure to "opt in" to a newsletter.

 

However the government chooses to look at what you're doing, there's still the matter of individual customers reporting you as a spammer, and finding your emails blocked in a large number of places. If you can remember back to the heyday of "AOLusers", a large number of them would click "Report as Spam" in order to unsubscribe from various mailing lists. This solved their immediate problem (no more mail from that sender), but falsely labeled legitimate (non-spamming) businesses as spammers, creating an enormous headache for them.