"Brett_A" <br********@gmail.comwrote in message
news:11*********************@i38g2000prf.googlegro ups.com...
I need to send an automated email each day (Member expiration
notices). The data sits in an SQL Server but SQL Mail is not
available.
Building an .asp page that makes this happen isn't a problem, but that
page would have to be loaded each day for the process to run.
Any ideas on how to make this happen?
Why not take the code in the ASP page put it in a VBScript file and set up a
scheduled task to execute it daily.
Control Panel | Scheduled task | Open
File | New | Scheduled Task
Rename the task to something sensible.
Open properties of task
For task to run browser to system32\cscript.exe then add the the filename
of the vbs file as a parameter.
Set Start in to the folder the VBS file is in. Configure Run as for the
user that task should run as.
Other settings are pretty self explanatory.
--
Anthony Jones - MVP ASP/ASP.NET