Results 1 to 4 of 4
  1. #1
    chris007 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Location
    Australia
    Posts
    2

    get automated email based on calendar time

    Hello,
    Sorry if this is in the wrong area just new to this forum and in fact Access Forums.
    My question is this:


    i want an email sent to two different locations via outlook.
    the emails i want to be sent Two months prior to an expiry Date, E.G if the expiry date is 1st Sept 2016 then i would like an automated email sent on 1st july 2016

    Am i able to do this?
    How do i do this?
    I am thinking in a Query based on the table that holds the expiration date? but not sure how to do it

    if someone is bale to assist i would be greatfull

    Thank
    Chris

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Here's a source for functions that you will likely find useful http://www.techonthenet.com/access/functions/

    Usually there are many ways to calculate something. Here's one related to your question: DateAdd("m",-4,Date)
    This will provide a date 4 months prior to today. To alter the period, the m (month parameter) can be changed.
    To alter the date, you'd supply an actual formatted date (e.g. DateAdd("m",-2,#06/23/2016#)
    or a reference to a form or query field that provides a date (e.g. DateAdd("m",-2,[SalesDate])
    In the example, Date is a reserved word for the Date function, so do not use "Date" anywhere in your db to name any object or field.

    As for the email part, I presume you know how to handle that because you provided no information around those requirements.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    chris007 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Location
    Australia
    Posts
    2
    Micron,
    Thank you for your assistance.
    I will try this in the morning sounds like and looks like should be easy.
    I have looked at other postings that appear complex for me.
    I am guessing the coding is done in a Query?
    Will loo at the link now
    Thanks Again for your Assistance
    Much Appreciated

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I am guessing the coding is done in a Query?
    It's quite common to use expressions to create calculated fields in queries. Whether or not that fits your requirements, I don't know but I can say it's easier than writing code for something that a query or calculated control on a form/report can provide.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automated Email Question
    By siggybaby_18 in forum Access
    Replies: 16
    Last Post: 12-02-2013, 08:48 AM
  2. Automated Email using Outlook
    By imran688 in forum Programming
    Replies: 25
    Last Post: 11-12-2012, 03:02 AM
  3. Automated Email Notification
    By sai_rlaf in forum Access
    Replies: 5
    Last Post: 12-07-2011, 06:33 PM
  4. automated email sent from records in form
    By hmcquade in forum Forms
    Replies: 2
    Last Post: 05-23-2011, 08:45 AM
  5. Automated email from access
    By jfuller in forum Access
    Replies: 3
    Last Post: 04-11-2011, 02:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums