Solved

How can a database automatically send email reminders when a due date is near?

Posted on 2014-09-04
3
2,106 Views
Last Modified: 2014-09-09
When the due date for a task shown on an Access database is over 45-days old, how do we have the program to automatically send a special reminder message to selected email addresses.  Once the email has been sent, a "Y" will be entered into a field called "Message_Sent".  From that point on, Another message will not be sent concerning those tasks.
0
Comment
Question by:sherman6789
3 Comments
 
LVL 1

Accepted Solution

by:
Radha M earned 500 total points
ID: 40304246
MS Access has no capability to do it.

You need to create an windows application which will access your Access database and check for the dates and send mails, create setup and install it in your machine.

Then, use the Task Scheduler option to call/run the application on a particular frequency.
0
 
LVL 57
ID: 40304284
Sorry, but I disagree with the accepted answer.

Access can *easily* do this, either as a called task or a task left continually running.   You can even have Access run in the system tray.

I do stuff like this all the time in a number of different ways.

Jim.
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 40312503
There are a few separate issues here:

Creating and sending the email

Our Total Access Emailer program makes this very easy by letting you interactively create an email blast with the list and message to send. The message can include values from your data source so each person receives their own personalized email. You can also attach reports as PDF files which can be filtered so that each person only sees their own data. More info here: http://www.fmsinc.com/MicrosoftAccess/Email.asp

Tracking Email Sent Date

Total Access Emailer has an audit feature so that when the emails are sent, a field in the data source is updated with the time it's sent.

Data Source Retrieves Late Items that Haven't been Emailed

In your situation, you'd create a query for your data source that retrieves the list of emails to send for the items that are 45 days late that haven't had the email sent field filled. You can then have that email blast sent once a day. If no records are found, no emails are sent.

Free Trial

A free trial is here: http://www.fmsinc.com/MicrosoftAccess/Email/free-trial.html

Hope this helps.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question