Results 1 to 3 of 3

Thread: email

  1. #1
    Join Date
    Nov 2004
    Location
    Ireland
    Posts
    25

    Unanswered: email

    How would you automatically send an email to certain user when a deadline is set in the database?eg..when an error is due to be fixed?

  2. #2
    Join Date
    Aug 2004
    Posts
    19

    Email

    Try this. Works fine to me!

    http://www.freevbcode.com/ShowCode.Asp?ID=109

  3. #3
    Join Date
    Sep 2003
    Posts
    228
    The link above would help with the emailing portion of your problem.

    In regards to your automating problem, I have a batch file on a server that is run nightly via Window's scheduled tasks program. The batch file is something along the lines of:
    "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "c:\my.mdb" /x "macro_name"
    I have a macro that calls a function which calcualtes who needs emails and then sends those emails. The last thing the macro does is a .quit to exit msaccess.

Posting Permissions

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