I need a new newsletter script... I have an existing table called "users" where all the emails are located. It should have a feature to only filter the emails that have field "newsletter" set to "yes". Is there such a script available?
In your case, you need to write some code to do this, also add stmp server. In another way, you can use rss to email functionality which was provided by the 3rd party, such as feedburner, now I used it as my newsletter sender. BTW, you can check the newletter box on my site, in the right side. http://www.joke4me.com
PHP List is a popular open source newsletter script. You can customize this to fit your need. There is a "confirmed" column, by which you can know that they have subscribed and confirmed their emails. Go for a demo here www.phplist.com/demo
there's a really cool one in the WordPress plugins repository. it has a whole bunch of features like how users can unsubscribe by sending an email to
I would also suggest looking into PHP List. It is an excellent newsletter tool. You can import all of your email addresses into into and manage the list easily. Just make sure you have a good host that will allow you to send out mass emails. Your hosting account may have also come with a newsletter script. Check cPanel to see if one exists.