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

 

[sfreeman@co.mer]

1) Is the db always running? If not, how will it run wihen the db is closed?

2) If you have the code to send the e-mail in place, then you need to set a timer event that will run, oh, every so often, maybe once a minute, or once an hour, if the system date/time equals the fieldvalue date/time, then run the macro or vba that sends the e-mail.

3) Same answer to run the query, use the timer event, assuming the db is always open.

If the db is not always open, then you should set up a Scheduled Task, and trigger this stuff off of an autoexec macro.

HTH

 

[guyinATL]

Good suggestions!

How do i actually setup a timer in MS ACCESS ?

DB is not always open, but i can leave it open, no problem with that.

R

 

[black.horizons]

in a form go to design view, then open the properties window.

Scroll down the all tab until you come to "timer interval"

this is in milliseconds...so 1000=1 second, 60000=1 minute.

then go to On Timer, and get it to run either VBA or a macro, job done easy peasy