Welcome to SPN

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

Sign Up Now!

generating a reminder e-mail

Discussion in 'Information Technology' started by David, Nov 11, 2005.

  1. David

    David
    Expand Collapse
    Guest

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

    Similar Threads Forum Date
    Sikh News Essay: As A Turbaned Sikh American, Flying After 9/11 Is A Painful Reminder Of Breaking News Sep 17, 2016
    Opinion Balbir Singh Sodhi’s turban at Smithsonian exhibition:A reminder of discrimination Breaking News Feb 27, 2014
    India Troubled Reminder - A memorial for Op Bluestar ‘martyrs’? Breaking News May 12, 2012
    Humble reminder: WHAT IS SEWA ? Sikh Sikhi Sikhism Jul 16, 2008
    Bhagats A Reminder From Bhagat Kabir Ji History of Sikhism Mar 23, 2008

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    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
    <Office/Access MVP>

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

    David
    Expand Collapse
    Guest

    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
    > <Office/Access MVP>
    >
    > "David" <David@discussions.microsoft.com> 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 ?

    >
    >
     
  5. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    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
    <Office/Access MVP>

    "David" <David@discussions.microsoft.com> 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
    > > <Office/Access MVP>
    > >
    > > "David" <David@discussions.microsoft.com> 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. David

    David
    Expand Collapse
    Guest

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

    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
    > need to (create query1; create query2, using query1 as the source).
    >
    > --
    > Regards
    >
    > Jeff Boyce
    > <Office/Access MVP>
    >
    > "David" <David@discussions.microsoft.com> 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
    > > > <Office/Access MVP>
    > > >
    > > > "David" <David@discussions.microsoft.com> 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 ?
    > > >
    > > >

    >
    >
     
  7. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

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