Send to E-mails from Access Table a Reminder

1 New Member

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

Subscribe Reply

1167

zmbd

5,501

Recognized Expert Moderator Expert

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.sendobject 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...0vba&gsc.sort=

Jun 29 '15 #2

Similar topics

11781

Python To Send Emails Via Outlook Express

by: ian | last post by:

Hi, I'm a newbie (oh no I can here you say.... another one...) How can I get Python to send emails using the default windows email client (eg outlook express)? I thought I could just do the...

Python

2657

Send emails to users stored on each record

by: slider | last post by:

Hey all i am using Access 2003 on Win Xp and i have been trying to make this code send emails to the users stored on each record. So far is works, except in the body of the email i need it to say a...

Microsoft Access / VBA

2935

receive and send emails in Access 2002

by: drnorbert | last post by:

What is the best way to receive and send emails in MsAccess? Could this be done without Outlook automatation?

Microsoft Access / VBA

1445

Cannot send eMails

by: Thomas Weise | last post by:

My app attempts to send eMails via SmtpClient. This works with some addresses, but for instance a mail server hosted by godaddy always rejects the mails. The reply is "Relay access denied". Does...

.NET Framework

1167

how to send emails without getting security prompt

by: manontheedge | last post by:

I'm trying to automatically send emails through VB, through Microsoft Outlook 2003, but get the security message ... "A program is trying to automatically send e-mail on your behalf. Do you want...

Visual Basic 4 / 5 / 6

1552

can't send emails from Outlook

by: =?Utf-8?B?eWVsbG93YnVn?= | last post by:

I have Windows Vista and when I try to send emails (new or replies), I get an error from McAfee saying to check the domain of the recipient and try sending again from my email program. I can't...

.NET Framework

846

Delay Send Emails

by: gauravbhati | last post by:

Hello, The task is to send emails in batch at specific times and not each time if user clicks on submit. Details: I have an InfoPath form which employees will use to putup request to update their...

.NET Framework

1541

Send emails directly from my email form in MS Access

by: JohanKotze | last post by:

I create a email form in Access that I want to use to send emails to my clients. Can someone help with the code. If its possible I can send the DB in zip format.

Microsoft Access / VBA

1834

Can I write my program to send emails?

by: Fuzz13 | last post by:

I am writing a program that will periodically scan for changes in a file, and if that file changes I need it to send out an email based on the email field that the user fills in. My question is,...

C# / C Sharp

4744

How to send emails automatically from an access database query?

by: MHutcheson81 | last post by:

I have a MS Access 2010 db taht I want to send emails from automatically. I have the query setup but am getting stuck with the CDO VBA. They query is call 'qryEmails' and contains the following 4...

Microsoft Access / VBA

7123

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7326

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7383

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7046

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7498

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5627

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4707

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3194

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

1557

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp