Auto email generate

[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. I have attached an example of the database in which I want to automate the emails for I have no experience with coding.

Thanks,
Nigel Herbert

[Bulzie]

Why post duplicate to this question from yesterday?
https://www.accessforums.net/showthread.php?t=67327

[nherbert31]

I was hoping someone could write the code within the database I uploaded.

[Bulzie]

Just add another post or edit your first one in the other thread to add the db file. You already have comments on that one. Never want to add a duplicate post really.

[June7]

Not really a code writing service. Learn how to program with VBA and attempt code (it's not that hard). Post attempts for analysis. https://support.office.com/en-us/art...0-DAB7C75CBE0C