Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Auto Email Reports

Discussion in 'Information Technology' started by MaggieMay, Jul 28, 2006.

  1. MaggieMay

    MaggieMay
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    MaggieMay <MaggieMay@discussions.microsoft.com> 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
     

Share This Page