Results 1 to 2 of 2
  1. #1
    JLoPresti is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    1

    Send e-mail to users when a field is null more than three days based on another date field

    Looking for some help here...


    I have a form in my Access 2016 database that has two date fields. When one field <record received> is populated with a date I need an e-mail sent to certain users when the other field <record reviewed> stays null more than three days from the date in the <record received> field.

    Thanks,

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Create a query that uses <Date()-3 in the criteria for record_received and Is Null for record_reviewed. Hopefully you can also include the email address field in here. Use the query as the record source of a form called frmReviewsRequired or something like that and add a button on it to send your emails (using docmd.sendobject or through Outlook automation).

    Cheers,
    Vlad

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

Similar Threads

  1. Add days to a field based on a text field
    By arbucklemw in forum Queries
    Replies: 4
    Last Post: 09-21-2017, 04:58 PM
  2. Replies: 4
    Last Post: 04-28-2017, 02:21 PM
  3. Replies: 1
    Last Post: 01-05-2017, 05:14 PM
  4. Replies: 1
    Last Post: 04-29-2016, 04:03 AM
  5. Replies: 20
    Last Post: 01-13-2015, 02:23 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