How to subscribe all customers to a newsletter at once?

I'm trying to figure out how to subscribe ALL my customers to my newsletter.

I could go to the customer-list in the admin control panel and set every customer to "subscribed" manually but with hunderds of customers this'll take a while.

So is there a more elegant way to set all customers to "subscribed" at once?

Don't do this. It's considered spam and can get you blacklisted.

You can send them all an email politely inviting them to sign up themselves, but you don't want to send unsolicited bulk commercial email. Just because they bought from you doesn't mean they want to hear from you.

I understand, but I've already figured out who wants to receive the newsletter and who doesn't (I've already sent everyone an email with a unsubscribe option).

Only a handful of people unsubscribed, so I figured I'll just subscribe everyone and unsubscribe that handful of people manually. That's not very spamlike isn't it :smile:

So, how would I go about doing this?

Thanks!

urm sounds like persistant go ahead. Glad I am not a customer :shocking:

If I understand correctly, you spammed all of your customers and offered them a chance to not receive future spam from you, and you're assuming that those who didn't unsubscribe want more spam?

As swguy said, this could get you blacklisted.

Always a good idea, I think, to make all commercial email opt-in.

Steve

In many countries, this is not legal...

I'm running a specialized business, a niche business if you will and I'm 100% sure that no-one that will receive my newsletter will regard it as spam.

I'm not asking if it is ethically correct :) after all, you wouldn't even know how to answer that question without more details from more side, I'm just asking how to do this :)

double post

If you know how to use MySQL, you could change the subscribe settings in the database via PHPMyMdmin with a couple of SQL commands.