How to create an automatic email for when something is due

[gbpg]

I ahve a database that tracks calibration equipment. There is an annual date
when things are due how can use an email be generated when it is 30 days from
the due date

 

[Alex Dybenko]

Hi,
you can do this on program start - check if this is a date of equipment
calibration, since last time program started, and then send email using
docmd.sendobject

Also you can use a hidden form with timer, to check this every hour

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com