Automatic Email Reminder

[Brachole]

I have this website in ASP/Database driven website. In the database, I have a table with Members and Expiration Dates of their registrations.

I want the website to be able to send an email reminder automatically when that expiration date is reached.

I think I need some kind of Server Side component for this...if so, which one should I be looking at and is this doable?

[yamaharuss]

On your new web server you can setup a daily batch script scheduled to run and query your database of subscribers. Based on date of expiration (or whatever) you can email members.

I do this with several things including birthday emails daily.

[NatuScape]

Care to offer more detail? I'm also interested in implementing this on a Windows 2003 server where I'm running a website off IIS.

Thanks!

Me :)

[yamaharuss]

It's extremely simple. Simply create a vbs file:

dailyreminder.vbs
myconnectionstring
mysqlquery (select from members where whatever)
do until....
mycdo script
next


Go to your window scheduler and schedule that file to run daily, weekly, etc.