Automated Email Reminder

Looking for PHP script to auto-generate & send an email reminder

[sparrow]

We have a database of clients that need to have reminders sent for installation payments. It would be nice to code it into the existing pages thus updating the existing table of the DB, but if need be adding another table to the DB to handle this.

Reminders need to be sent at maximum of 3 times and a minium of 1.

Does anybody have any suggestions.

Thanks

[andreasfriedrich]

You would need to make sure that the script is run regularly. If you have crond available use that.

I do not know of any readily available scripts. But since the whole script will be nothing more than one db query and a loop over all returned rows where you send the mail I doubt that such a script would be really useful since you would have to write the SQL query youself as no programmer would know yor conditions for sending email beforehand.

In the script query the database for all customers that need to be notified. You did not give enough information for me to know what the conditions for sending a reminder are.

Then loop through all rows that were returned and send a mail using the mail [php.net] function. If sending the mail was successful increase some counter in the db.

All in all it is a rather simple script.

Andreas

[sparrow]

I've found a script it's named "E*reminder" which I found at SourceForge.net. Looks like it will do what we want.
Has anybody used this before and have any comments?