Send to E-mails from Access Table a Reminder

[codrmur]

Access 2013

I am very new in Access.

I have a table with the cursant name, course, expiry date, email address of the cursant. I want Access to automatically send to each coursant an email which notifies them about the course expiry date, with 2 months before.

Can you help me with this?

[zmbd]

codrmur:


1) Normalization is your friend!
Please read thru the following article in our insights directory: Database Normalization and Table Structures

2) Sending multiple reports will be come easier once you have the database properly normalized and designed. You do not mention if you are sending via email, snailmail, hand delivery, or carrier pigeon ( :D ). If you are using outlook the docmd.sendobjec t method is the most straight forward for simple emails for sending reports. If you will use the bytes.com search tool using keywords Access EMAIL and include one of the expert/moderator names (NeoPa, Rabbit, Jforbes, Seth Schrock, ZMBD, etc...) you will turn up many threads covering this topic in great detail.

- if you have a specific question or sticking point we can provide you much better guidance.


More advanced:
Application Automation

Keep in mind that Access expects VBA dates to be in the #MM/DD/YYYY# format.

Once you have your query and your code put together if there are still sticking points post back.

and a simple search here on bytes:

http://bytes.com/searchresults.php?q=ms%20access%20docmd.sendobject#gsc.tab=0&gsc.q=access%20send%20email%20vba&gsc.sort=