VBScript (.asp & on local server) to send an appointment

We have a very simple appointment scheduing system on our
website. Data is stored in an SQL DB. Visitor selects an
appointment, inputs name and email, and saves.

Later, a staff person is assigned. Here is what I want.

They are assigned via a web interface. When assigned I
want to sent that person (the staff person) an appointment
via email to Outlook.

Also, I would like the ability to send those appointments
in the AM using a scheduled VBScript routine on an
internal Win2k server. The routine would run every
morning (at approx 2:00am) and send any appointments for
that day (appointments cannot be made for the current day
so there is no chance of losing an appointment).

Exchange is not running on the web server and/or on our
internal server.

Can this be done?

Thanks,
Matt Moran

petal
Thu Jul 10 17:23:26 CDT 2003

How do I send e-mail from SQL Server?
http://www.aspfaq.com/show.asp?id=2403

regards
petal


"Matthew Moran" <mmoran@cbtoolkit.com> wrote in message
news:04fc01c3464b$c32a0bb0$a101280a@phx.gbl...
> We have a very simple appointment scheduing system on our
> website. Data is stored in an SQL DB. Visitor selects an
> appointment, inputs name and email, and saves.
>
> Later, a staff person is assigned. Here is what I want.
>
> They are assigned via a web interface. When assigned I
> want to sent that person (the staff person) an appointment
> via email to Outlook.
>
> Also, I would like the ability to send those appointments
> in the AM using a scheduled VBScript routine on an
> internal Win2k server. The routine would run every
> morning (at approx 2:00am) and send any appointments for
> that day (appointments cannot be made for the current day
> so there is no chance of losing an appointment).
>
> Exchange is not running on the web server and/or on our
> internal server.
>
> Can this be done?
>
> Thanks,
> Matt Moran