generating a reminder e-mail

[David]

Is it possible to automatically generate a reminder e-mail at a specific date
e.g. amonth before a deadline such as a passport expiry date ?

 

[Jeff Boyce]

David

A couple approaches...

One would be to purchase a commercial piece of software that can
select/schedule emailing from an Access db.

Another would be to create the pieces for your application to do it. You'd
need to know a month before a date -- do that with a query. You need to
know an email address -- do that with a query. You need to know that an
email was already sent for a given "account" -- you could use a table with a
date to record sent reminders. And you need to send an email -- Access can
use SendObject to do that.

 

[David]

Hi Jeff,

Thanks for your help.

When you suggest a query for each piece, could these all be part of the same
query ? I'm afraid I'm not very advanced !

 

[Jeff Boyce]

David

I can't see your data, so I have no idea if you could use a single query to
return everything you need. But you can "chain" queries together if you
need to (create query1; create query2, using query1 as the source).

 

[David]

Thanks Jeff, I'll play around with it. It's not that an improtant issue to
warrant buying new software.

All the best.

David

 

[Tony Toews]

Is it possible to automatically generate a reminder e-mail at a specific date
e.g. amonth before a deadline such as a passport expiry date ?

Using VBA code, with a query which looks at the tickler date based on
todays date. I.e. <= Date(), set a flag in those records as "about
to send emails", loop through the recordset to send the emails, update
the flag as "sent emails", and a sent date. Repeat tomorrow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm