I
Ivan R via AccessMonster.com
I need to know if it is possible to send an email to users from access, based
on the results of a query. The query will list the user and when there last
update to a table was. Then it will send a automatic email to the users if
they have not accessed the table in a certain amount of time.
The application of this is, I have a form and table which records time sheet.
However there are occassions when the users will not enter their time into
the db because they were absent, sick, on vacation etc... I want the query
to find out how much time has gone and if it is over a certain amount of time,
to send each detective a message asking them to update their time. If they
are under the limit, then they will not get the message.
on the results of a query. The query will list the user and when there last
update to a table was. Then it will send a automatic email to the users if
they have not accessed the table in a certain amount of time.
The application of this is, I have a form and table which records time sheet.
However there are occassions when the users will not enter their time into
the db because they were absent, sick, on vacation etc... I want the query
to find out how much time has gone and if it is over a certain amount of time,
to send each detective a message asking them to update their time. If they
are under the limit, then they will not get the message.