Send email remider 3 days before appointment

[CHEECO]

I have a appointment database and I would like to have the database automatically send a email reminder with app date and time 3 days before the appointment. I have looked around and found code to send a email but no 3 days before the appointment. I am using Access 2016 m2 bit.



Thank-you

[RuralGuy]

So the email date is the Appointment - 3 days, right? You dould use DateAdd() to get the trigger date.

[pbaldy]

You could open a recordset with a criteria to get the appropriate records. Loop that and send emails to each. Personally, I'd probably create a stand-alone db that did just this, and run it from Windows Scheduled Tasks every day.

[pbaldy]

Oops, slow fingers.

[RuralGuy]

Oops, slow fingers.

They're probably tired from shoveling snow.

[pbaldy]

They're probably tired from shoveling snow.

Not so tired as yours must be, since I'm 3,500' lower.

[CHEECO]

I will give the - 3 days a try. Does have any one have a good working code that I can work with.

[Micron]

you haven't provided enough info for anyone to provide code or an expression. Take a look at the DateAdd function here, though I think I'd use the DateDiff function (also available at the same web site) and send the email if the difference between Date() and the appointment date >= 3.
https://www.techonthenet.com/access/...te/dateadd.php

[CHEECO]

Thank-you and yes you are correct I have not provided much info. I have attached a copy of the database.

[pbaldy]

If I'm reading right, the SQL to pull appointments 3 days out looks like:

SELECT tblAppointment.AppointmentID, tblAppointment.Subject, tblAppointment.StartTime, tblAppointment.EndTime, tblAppointment.Email
FROM tblAppointment
WHERE (((tblAppointment.StartTime)=DateAdd("d",3,Date()) ));



I'd create a saved query with that SQL, open a recordset on it and loop the records, sending an email to each.

[CHEECO]

Thank-you I will give that a try.

[pbaldy]

No problem, post back if you get stuck.