Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page