Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: How automatically send an email from access

    Hi There,

    Can anyone please advice on how to automatically send an email from access based on a future date on a field (i.e. when the date on a certain field of a record is the same as todays date, send an email automatically).

  2. #2
    Join Date
    Feb 2005
    Posts
    20
    hi

    you have to compare the 2 dates for example in the onopen procedure of your form and if the two dates are the same you can use

    docmd.SendObject ,,,"here@iam.com",,,"automatic message","text",false

    that's it

Posting Permissions

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