Solved

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

Posted on 2014-09-04
3
1,937 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
Comment Utility
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

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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:LukeChung-FMS
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now