Results 1 to 4 of 4

Thread: Auto Email

  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: Auto Email

    Hi ,

    I have just made a database for employees to submit data daily into the system. I'm looking to set it up to check the date and Employee Name in the table and if nothing has been submitted by a certain time that day, send an auto email out to a given address. Is this possible? If so, can I get some basic codes to help out?

    Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, it's possible. I use SMTP to do it, bypassing outlook.

    Sending Mail

    hth
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2009
    Posts
    2
    Thanks for that!

    I've got the email part working, but how would I go about getting it to check if there is a record for a certain employee on a certain date?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Use a query?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •