Database triggered auto-email?

C

Clark

My site is FP2000 - generated, operates in a Windows environment, uses Access
for the database, and has several DRW-generated queries in operation.

The database records all contain email addresses and a timestamp indicating when
the record was added among other things.

What I hope to do: I would like to automatically email all the email addresses
in the database whose timestamp is 90 days old. I know how to make an Access
query that produces the emails.

I have two questions:

1. What tools would be required to pull this off?
2. Will I need special things running / available at my host?
3. Can someone point me to code examples and/or useful reading to bone up on
this?

Thanks
 
T

Thomas A. Rowe

You just need to write the emailing functions that loops thru the recordset and then sends the email
via CDOSYS or CDONTS. Just do a search in the IE address bar as:

? ASP Sending Email CDOSYS

or

? ASP Sending Email CDONTS

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top