Email Reminders

[Little Penny]

I have a table of laptops and users table. Joined by a one to many relationship. In the Laptops table there is a field call LastUpdate (Windows
Patches) there is also a field called nextupdatDue. In my Laptps form the field is automatically filled in by (Me.NextUpdateDO = Me.LastUpdate + 45).

Is there a way to have email reminder sent to the user 5 days before due date and reminder the database user if due date expires.


Any suggestions greatly appreciated.




Thanks

 

[Guest]

Hi,
first of all you should NOT store calculated values in tables. You can
calculate these at runtime in queries or on forms and reports.
Create a query which will filter out the people who need a reminder. Use the
criteria to calculate 5 days prior to the calculated due date. After that you
have to specify what you mean with automatic. Will the db be open 24/7 and
you want it to then do this automatically without user interaction, or does
someone manually open the db everyday and you want it then to automatically
check and send, or does no one open it or is guaranteed to open it and you
want to have it automatically open every day and check if anyone is in the
query and send emails based of that?
HTH
Good luck

 

[[MVP] S.Clark]

The SendObject method can be used to send emails. A simple query can
determine when 5 days prior to the due date is.

If you need to do more emailing, this product is very helpful:
http://fmsinc.com/products/emailer/index.asp