Dear All,

My manager has been asking me for this for months but I never managed to get this working.

I was wondering whether someone would be kind enough to guide me through on how to set up or write a code in MS Access database to send automated email reminders through ms outlook.

Basically, I want to the database to send 3 different reminders at different intervals. For example if a student has not returned the books back to the library 30 days after it was taken, the system should bring up a popup screen informing the user that "would you like to allow this reminder to be sent to x or y" Also the user should be able see what is being sent before clicking Yes or NO. if clicked yes, then the body of email should include the following
information so the student will know what we are chasing them for:

Date book was taken NameOfBook FeePaid FinedAmount

Any advice on this would be highly appreciated.