Quick question.

Database fields - date, info, id

Is it possible to automatically email a recipient (same person each time) when it is 6 weeks prior.

Ie if the date was 25/12/02 you would get an email around middle of October with the information from the info field.

Cheers

Perry

....It's only easy if you know the answer

i don't have the answer, but i have a comment:

i think you'd have to set up some kind of script on the server which would execute itself each day to check wether any records are within the 6 week period. Aside from that initial obstacle, you'd need to calculate dates, and then create a recordset that would filter the records accordingly....

i'll keep thinking about it.

------------------------
Poolio

MSN:

www.eliziumdesign.com

before you start, check out a list of "reserved" words in access.

you cant use "date" as a field, as this is a reserved word. Use something like "EntryDate" + "MailingDate"

Regards,
Dave

UD4 || Flash || Access ||Web Hosting

Hi Poolio, I have heard about running script on server automatically, checking dates and launching application when the date meets, someting like DRONJOB in Unix.

How do we go about it in windows platform? I have been cracking my head for quite some time but still to no avail. If you should know how to, please enlighten me.

Perry, have you got the answer already?