Email Alert - repost

[ddunks]

Two things -

I have a form where the new project is entered, person assigned, and a start
date checked (list of check boxes - start month to be checked). What I need
is to have an email automatically sent to the assigned person when the start
date is selected.

Next, each project has a due date. I need to have an auto email sent to the
assigned person the day before it is due, if the 'completed' box is not
checked. And the day after to alert it is past due.

Hope this makes sense. Any help appreciated!!

 

[Pieter Wijnen]

basic
docmd.sendto
seccondary
a timer on a (hidden) forn to perform the additional tasks

Pieter

 

[ddunks]

Thanks! I have been trying the docmd.sendto - but am not sure how to make it
grab the person's name in the "Responsible" and find its email in the email
table. I'm new as you can tell!

I've never used the timer - so will look into how to do that! Thanks!

Darcy

 

[ddunks]

Another question - does the db have to be open for the timers to work?

 

[John Vinson]

does the db have to be open for the timers to work?

Yes, it does. Code that is not executing can't do anything!

If you want timers which are independent of Access, use the Windows
Scheduler (which can launch an Access database if you wish).


John W. Vinson[MVP]

 

[ddunks]

Thanks I will look into scheduler!

Yes, it does. Code that is not executing can't do anything!

If you want timers which are independent of Access, use the Windows
Scheduler (which can launch an Access database if you wish).


John W. Vinson[MVP]