We are in need of a mailing program to be run from a remote machine (preferably compatible with Win98, ME, 2k, and XP) - as opposed to being run from the server itself.
The program should have the capability to mail a specified message (with ability to do so either in text format or in .html) to a database (preferbly in .csv or tab delineated format). It should allow variables within the message to be sent for name, address, e-mail address, phone number, etc. We need the ability to add new emails through .csv or regular text files and clean the emails in the list for duplicates and if the user has already unsubscribed.
The program must be configurable to allow the user to send out e-mails in specific volumes (e.g. 100 e-mails per half hour). The program should have the ability to use multiple pop servers for mailing, and thus the ability to set different allowed e-mail volumes per server (100 e-mails per half hour on one server, 300 e-mails per 2 hours on another server, etc.) The program would begin on one server and mail the list until it reached the limit, then cycle to the next server down the line until all listed servers had reached their maximum, and then wait until the time limit had expired for another server to be available, and start again. This cycle would continue until the mailing project was finished, at which time the mailing program should say that the project was completed and it is ready for the next project. Also, the program should allow for connection through a proxy, and should allow connections via SMTP as well as SMTPS.
Obviously the software must have the capacity to "remember" where it is in the database so it can continue where it left off.
As a side, but much related project, we also need an unsubscribe form script (to be run on a UNIX host -- probably best done in .php). All e-mails would contain an unsubscribe link to the script, which, if clicked on would remove the clicker's entry from the database (or create a daily list of unsubscribes to be deleted from the database manually or filtered against the active list for further mailers).
The unsubscribe part of the project is exceedingly important, as our lists are double opt-in lists where people have requested the information that we are mailing. It is obviously in our best interest to make sure that anyone who decides to be taken off the list is indeed removed so as to avoid spam complaints with our host. The unsubscribe should be done as:
You are receiving this email as your are subsribed to receive the [url removed, login to view] promotions, To unsubscribe: Click Here
[url removed, login to view]