Generating Automated Email through Query

[nherbert31]

Hello,



I am fairly new to Microsoft Access and am trying to generate automated emails for my supervisor 90 days prior to the due date. I have a master table from which I created a query that lists all of the information I need. The fields that are included in the query are the employee name, email and due date. I also added a 'NumDay" field within the query which calculates the difference between the due date and todays date. I want to know how to create a module or query which can generate automated emails of the employees once the "NumDay" field reaches 90.

Thanks,
Nigel Herbert

[RuralGuy]

My favorite email link: http://www.granite.ab.ca/access/email.htm

[Bulzie]

Nice link Rural.

Nigal I think maybe first one in link might work for you "Sample Code illustrating looping through a DAO recordset"

Basically you want to run code that will loop through your query and send an email for each record. This can be placed on a Button for manual trigger or can be on say the OnOpen event of a form, you would add code at the end to Quit the Database. You would set this up to run the database on the PC Scheduler so it will open at a set interval, run the code(send the emails), then close the database and wait for the next time to run.

[June7]

If you want the email procedure to automatically run at scheduled times, say every night after 6pm, the only way I could figure out how to do that is with a VBScript and then set a task in Windows Task Scheduler to run the script. Review https://www.accessforums.net/showthread.php?t=21555