Due date email

[windwardmi]

One entry on our form for instruments requests a due date for calibration.



What type of code is involved for sending an email when that due date occurs or for 10 days prior and 10 days after due date.

I am not familiar with VB code writing.

Obviously the Db should be open to have this happen. So this I assume should be triggered on open.

I went to MS support Article 161088 and this doen not seem to help

[pbaldy]

Personally I would probably create an mdb that performed this process when it opened, then closed itself. Then I'd call that mdb from Windows Scheduled Tasks on the desired schedule. If you do it on open, it could happen more than once or not at all. You could create a query that returned the relevant items, create a report from that and use SendObject to send that report.

[windwardmi]

Ok, I can use Windows Scheduled Tasks to open up the program daily or on bootup.

Still if not triggered by Programto do the task the operator will not do it.

Can I have the program start and if a due date is due display a message to carry out task to send email? Can this task be automated on closing opening message to send email and cancel task.

Sounds complicated and code beyond my knowledge.

What do you think? Should we go further?

[pbaldy]

Virtually anything is possible; you need to land on exactly what you want to do and where/when.

[windwardmi]

I will go further with the application and get back to this issue later. Thanks for the help.