Results 1 to 4 of 4
  1. #1
    DJohns is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Midlothian, TX
    Posts
    6

    Question Send notification to external user when a new record has been created


    I am putting together a purchase order system and would like to automate the sending of the record(s) to the supervisor for approval.
    Any help would be greatly appreciated.

  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,818
    What do you mean by 'automate'? Send records how? Some event must occur for something to happen: form open, button click, form close, database open, etc. Then code can compile content for body of email.
    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
    DJohns is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2011
    Location
    Midlothian, TX
    Posts
    6
    Click a button to send the record to user.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Really not giving enough information to provide any meaningful answer - why send an email? To one manager? different managers depending on something? How are they supposed to respond? what does the email contain? do multiple records apply to one order/approval or many?

    Why not just have a boolean field called 'approved' and initially set to false. If the form is opened by a manager, it can be filtered to just show those records which are not approved - they can then tick to say it is approved

    and if you want to send an email - google 'CDO' - here is an example https://access-excel.tips/send-email...ct-olmailitem/

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

Similar Threads

  1. Replies: 2
    Last Post: 06-10-2020, 10:23 AM
  2. Created database for multiple user
    By adnancanada in forum Forms
    Replies: 1
    Last Post: 05-15-2017, 08:25 PM
  3. Replies: 3
    Last Post: 11-18-2015, 05:39 PM
  4. Replies: 2
    Last Post: 03-07-2015, 01:58 AM
  5. User created Hyperlink
    By kaylachris in forum Forms
    Replies: 3
    Last Post: 05-17-2010, 02:40 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