I own several membership websites and am looking for an easy way to keep in touch with my members...
I am looking for a way to send sequential emails, and also one time 'announcement' type emails. Up until now I have been using external autoresponders, but this is becoming cumbersome.
I would like a php mailer (or if you know a better way I am all ears) that would get the subscribers info from my current sql database, with a few modifications, we would probably need to add a 'messages' table.
I need to have a 'throttle' variable on the mailer, to keep the load lighter on my server. I have one membership site with over 40K members...that would be way too much to try and blast out all at once, so something like an email every 5-6 seconds should be manageable.
Also the ability to send in batches, say 500 at a time. I would then just run this script via cron once an hour. I would like to be able to do this so I can send out the announcement emails as a priority, and jump the queue...in the messages table we would just have a 'message_type' and label announcements '1' and sequentials '2', and then sort by the priority...I hope that makes sense.
I am pretty confident I could do everything up to this point - but rather than have someone come into my hacked-together script it might just be easier for you to start fresh...
Here's what I don't know how to do:
I would really like this script to keep track of bounced emails, so that I am not continually trying to send emails to someone who has an invalid email address; something like a 3 strikes and you're out system that would set the member to 'un-subscribed' (which I would just add to my members table).
I assume we would need to create a 'bounceback' email address for this purpose...
Once the email was sent it would set the 'sending' field to 0, so that it would just skip past all the ones that have been sent...I have a feeling we need to keep track of sent messages to figure out bounced emails - if not it would probably be easier and faster for the script to just delete that entry from the 'messages' table after sending.
I have worked in unix operating systems for automating tasks, such as this. This project seems very simple to implement and I expect it done in less than 3 days. As part of this project, you may not have realized bu Daha Fazla