Results 1 to 4 of 4
  1. #1
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34

    Email notification when a drop down is changed

    Hi all,

    Using the default task management template from microsoft:

    https://support.office.com/en-us/art...s=en-001&ad=US

    I am using the default form, but will add a 'Requestor' field. Can anyone tell me how to write a macro to email a 'requestor' when the 'status' of an issue is changed to anything apart from 'Not started'. By the default the requestor would have this on 'Not started'.

    Thank you!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Code would have to be in some event, possibly the AfterUpdate of control bound to the Status field. Something like:

    If Me.Status <> "Not started" Then
    DoCmd.SendObject acSendNoObject, , , "email address", , , "some subject", "some message"
    End If
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34
    Hi June7

    Thank you for your message

    Would you be kind enough to tell me how I go about implementing your instructions? Where do I begin to write the macro? Or do I create a macro and then somehow assign it? sorry i`m still learning!

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The example is VBA, not macro. I don't use macros. However, the SendObject method is available in macro builder. Will have to click on "Show all actions" in the macro designer to see it in the list.

    There are 3 types of macros - Data, Embedded, General.

    Start with review of https://support.office.com/en-us/art...7-70649e33be4f
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Database email notification 'from' address
    By jtm013 in forum Programming
    Replies: 3
    Last Post: 12-23-2014, 01:36 PM
  2. email notification with proper format
    By joshynaresh in forum Access
    Replies: 5
    Last Post: 02-04-2014, 10:17 AM
  3. Email Notification
    By Ariuser in forum Programming
    Replies: 1
    Last Post: 01-20-2012, 03:44 PM
  4. Automated Email Notification
    By sai_rlaf in forum Access
    Replies: 5
    Last Post: 12-07-2011, 06:33 PM
  5. disable email notification by Outolook Express
    By maxbre in forum Programming
    Replies: 0
    Last Post: 12-02-2011, 05:19 AM

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