email reminders

[jon98548]

In my assessment database I have a DueDate when resolutions for findings during an assessment are due. I would like an email to be generated as a reminder 30 days from the due date. Any ideas? Thanks.

 

[jekirksey]

I have a database that does this, I use the sendobject.sendreport command and loop through the records

I put the code on the on open event of the default form and I use Task Scheduler to run the database at a specific time everyday.

 

[jon98548]

I posted a new with more details because I forgot I had posted this. I'm not well. Anyway, I set mine up a little different and would like an opinion. It sounds like you set up a recordset to loop through as opposed to setting criteria on a query. True? Also, did you set your report to open when the database opens to run it automatically. Thanks for the help.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44242