By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,655 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

Send to E-mails from Access Table a Reminder

P: 1
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?
Jun 29 '15 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397

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.sendobject method is the most straight forward for simple emails for sending reports. If you will use the 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:
Jun 29 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.