I have a site for my clients where they can log in and check their account status etc. Shows them when they are due for renewal and simple stuff like that.

In one of my tables with the "tblExpiryDate" field, I'd like to have an automatically generated mail (CDONTS) send them a renewal notice 2 weeks before they expire.

If rsThisUser("tblexpiryDate" Date 14 days to go
Create a mail and filter the recordset
and Send it, then notify me of sending it.

It's a real small db in access2000, vbs & asp



Regards,
Dave

UD4 | Flash 5 | SQL | Access | ASP/VBScript | XP-Pro

hey up dave

not tried this but what the heck

stick an extra field in your db, "reminded" with a default of No.
then try summat like this
SELECT *
FROM rsetusers
WHERE (rsetusers.expirydate<Date()+15) AND rsetusers.reminded= 'No'

use this to send your mails and then update the reminded field to 'Yes' so it wont send em again.

dave




ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome