Welcome to SPN

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

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

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