Due Date

[jbento]

All,
I have a dueDate field on a form and I have a date in that field of 3/15/04.

I would like for the database to automatically send an email to recipients 10 days before the dueDate is met.

I have the code for sending the email, but I don't know how to get the dueDate field to trigger the email automatically.

Can this be done even if the database is not opened, or does the database have to be opened to send the email?

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[thecreator]

Either that database will need to be open (for your code to run) or you will have to link your table to it from an open database.

Have you thought about running a batch function every day? Find a timer on the internet that can run a DOS line. Put your database and the path to Access in the timer.

In your database, have an AutoOpen macro that calls a function to run through the table, check the date and if needed send an email. The last line of the function is to close the application.

I do something similar to build a small data wharehouse at 6:00am every morning and it works like a treat.

Cheers

 

[jbento]

Ok, I will just do it when the database is opened, but what would the code look like to do a email 10 days before the due date?

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!