Automatically Send Email When Date in Table = Current Date

[guyinATL]

Hi All !

Thanks for all the help i've been getting here, im making good progress. One day i'll be proficient enough to save some other geek's life

Here's what i'm trying to do.

A table has a date column. I want to send out an email to X number of recipients when that date/time e.g Nov 01, 2004 5pm is reached. Is there some way i can use a macro or setup a module with some VB code or some trigger in Access 2000 to send an email when a certain date is reached.

On a similar note, when that date is reached, i want to run a query.

Any views/suggestions?

Thanks!
R