Send an email automatically based on value of field

J

John Conklin

Hello all,

Can anyone point me to an example of how to send an email automatically when
the users set a value in a certain field in my database?

I have a field called Urgent Time, and if a value is entered in that field I
want to automatically send an email to four people notifying them of the
urgent issue.

Any suggestions appreciated.

Thanks,
~John
 
M

[MVP] S.Clark

In the AfterUpdate, use the SendObject method when the criteria is correct.

Something like:

If chkUrgentTime then
docmd.sendobject ...
end if
 
Top