Send an email automatically based on value of field

  • Thread starter Thread starter John Conklin
  • Start date Start date
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
 
In the AfterUpdate, use the SendObject method when the criteria is correct.

Something like:

If chkUrgentTime then
docmd.sendobject ...
end if
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
field value concatenation VBA 1
automatic email 7
Flag Up when an entry is made in a field. 1
How To Send Record via email 5
Access - automatically add email extensions 0
hyperlink field to send email 6
How to finding student Rank and How to upload bulk marks of each student at a time. 1

Back
Top