need to set up a database that will automatically generate reminder letters
for my clients such that every 6 months it will remind them that it is time
to set up an appointment or if a certain event happens like an oil change ,
that it will generate a post card in 6 months to remind them that they should
schedule a tire rotation and tune up.

I have access 2003 on a windows xp machine.

I can set up the database but can't figure out how to make it automatically
generate responses. Can the responses be an email generated automatically
from access? I would appreciate any insight you could give me.

--
May MacKenzie
Administrative Assistant

MaggieMay <(E-Mail Removed)> wrote:

> need to set up a database that will automatically generate reminder letters
>for my clients such that every 6 months it will remind them that it is time
>to set up an appointment or if a certain event happens like an oil change ,
>that it will generate a post card in 6 months to remind them that they should
>schedule a tire rotation and tune up.
>
>I have access 2003 on a windows xp machine.
>
>I can set up the database but can't figure out how to make it automatically
>generate responses. Can the responses be an email generated automatically
>from access? I would appreciate any insight you could give me.

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 print the reports,
update the flag as "sent emails", with 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