Q
Qaspec
I'd like for access to automatically send an email if a few values in a
record in a table match a certain set of values.
Table "Data1" has columns named "Date", "Status", "TL","Sent".
If the date in the record is 48 hours old and the "Status" column = open I
would like access to automatically send an email to the individual listed in
the "TL" column. Once the email is sent I'd like the "Sent" column to = Yes.
The value in the "TL" column in "Data1" would have a relation to the Name
column in the "Contact" table. The contact table stores the email addresses
in the "email" column.
Your help is greatly appreciated.
Qaspec
record in a table match a certain set of values.
Table "Data1" has columns named "Date", "Status", "TL","Sent".
If the date in the record is 48 hours old and the "Status" column = open I
would like access to automatically send an email to the individual listed in
the "TL" column. Once the email is sent I'd like the "Sent" column to = Yes.
The value in the "TL" column in "Data1" would have a relation to the Name
column in the "Contact" table. The contact table stores the email addresses
in the "email" column.
Your help is greatly appreciated.
Qaspec