generating a reminder e-mail

#1 (**permalink**) 11-Nov-2005, 20:09 PM

Is it possible to automatically generate a reminder e-mail at a specific date
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7189-generating-a-reminder-e-mail.html
e.g. amonth before a deadline such as a passport expiry date ?

*

#2 (**permalink**) 11-Nov-2005, 20:09 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
date to record sent reminders. And you need to send an email -- Access can
use SendObject to do that.

--
Regards

Jeff Boyce

"David" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
news:290D917D-232C-41D0-A736-27E9E1B10EFF@microsoft.com...
> 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 ?

#3 (**permalink**) 11-Nov-2005, 20:09 PM

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 !

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
"Jeff Boyce" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
> use SendObject to do that.
>
> --
> Regards
>
> Jeff Boyce
>
>
> "David" wrote in message
> news:290D917D-232C-41D0-A736-27E9E1B10EFF@microsoft.com...
> > 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 ?
>
>

#4 (**permalink**) 12-Nov-2005, 22:39 PM

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).

--
Regards

Jeff Boyce

"David" wrote in message
news:F2B26149-34AB-43F7-ABE0-B733E9A7D25B@microsoft.com...
> 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" wrote:
>
> > 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.
> >
> > --
> > Regards
> >
> > Jeff Boyce
> >
> >
> > "David" wrote in message
> > news:290D917D-232C-41D0-A736-27E9E1B10EFF@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
> > > Is it possible to automatically generate a reminder e-mail at a
specific
> > date
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
> > > e.g. amonth before a deadline such as a passport expiry date ?
> >
> >

#5 (**permalink**) 12-Nov-2005, 22:39 PM

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
All the best.

David

"Jeff Boyce" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
> need to (create query1; create query2, using query1 as the source).
>
> --
> Regards
>
> Jeff Boyce
>
>
> "David" wrote in message
> news:F2B26149-34AB-43F7-ABE0-B733E9A7D25B@microsoft.com...
> > 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" wrote:
> >
> > > 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.
> > >
> > > --
> > > Regards
> > >
> > > Jeff Boyce
> > >
> > >
> > > "David" wrote in message
> > > news:290D917D-232C-41D0-A736-27E9E1B10EFF@microsoft.com...
> > > > 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 ?
> > >
> > >
>
>

#6 (**permalink**) 12-Nov-2005, 22:39 PM

"David" wrote:

>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7189