daydreamer Posted July 31, 2009 Share Posted July 31, 2009 I have around 300 emails that I want to send to, in a mysql database. What is the best way to go about it? Write a script to send a text based email to them, or extract them to .csv and get a third party program? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/168332-best-way-to-mass-email/ Share on other sites More sharing options...
Mardoxx Posted July 31, 2009 Share Posted July 31, 2009 IDK but i'd write a script.. although the server may be limited to # of emails it's aloud to send /unit of time make a simple mail(); script and just smack in some sql to get the email from the database <?php include('connect.php'); $query = "SELECT * FROM emails"; $from = "your@email.com"; $subject = "YOU SMELL"; $message = "REALLY NICELY"; $headers = "From: $from"; while ($row = mysql_fetch_assoc($query)) { //send email script using $row['email'] as the email $to = $row['email']; mail ($to, $subject, $message, $headers); } Quote Link to comment https://forums.phpfreaks.com/topic/168332-best-way-to-mass-email/#findComment-887950 Share on other sites More sharing options...
Zane Posted July 31, 2009 Share Posted July 31, 2009 never tried this but it would seem like a feasible solution send the entire comma separated list of emails as a blind carbon copy. so instead of making the string say To: have it say Bcc: Quote Link to comment https://forums.phpfreaks.com/topic/168332-best-way-to-mass-email/#findComment-887965 Share on other sites More sharing options...
Mardoxx Posted July 31, 2009 Share Posted July 31, 2009 hey, zanus, that's pretty good actually lol export it and copy and paste into thunderbird or whatever >_< Quote Link to comment https://forums.phpfreaks.com/topic/168332-best-way-to-mass-email/#findComment-887975 Share on other sites More sharing options...
daydreamer Posted August 1, 2009 Author Share Posted August 1, 2009 I wrote a script, but my SMTP server started rejecting all emails after around 5mins obviously to prevent spam/overload. So how can I send the emails? Does anyone know of software I can use? Quote Link to comment https://forums.phpfreaks.com/topic/168332-best-way-to-mass-email/#findComment-888262 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.