Hi sfolwer39,
Yes you can do it through phpMyadmin quite easily. I don't know your table prefixes and don't want to give you a bad query but it would take just a second or two to make a change like that across 500 users.
I don't know what type of forum you're running, but unless it is a real privacy concern, I would go ahead and send your first newsletter and test the water. Newsletters aren't sent to anyone who has Receive Admin Email disabled and your newsletter is an admin mailing, so it should be legit.
Be sure to include at the top of your newsletter an instruction similar to the following
Quote:
This bulletin is emailed (monthly/weekly/whatever) to members of the whatever community. If you are receiving more than one copy it is possible that you have multiple registrations. Instructions at the bottom of this message detail how you can adjust your newsletter settings. If you are unable to do this, please forward a copy of the newsletter to newsletter@whatever.com and let us know if you want to unsubscribe or remove your registration entirely. We have a zero tolerance policy toward spam.
|
Regards,
Matt