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
    8,771
    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.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  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
    8,771
    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 - Senior Forums