Email Alert - repost

D

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!!
 
P

Pieter Wijnen

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

Pieter
 
D

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
 
J

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]
 
D

ddunks

Thanks I will look into scheduler!

John Vinson said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top