View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Send Email: Once priority is changed

How can I send an email if the value of a certain field changes to something.

For eg: If Priority field changes to 5 I want to send an email to myself.

I know how to get the email working on click of a button on the userform,
But dont know how to get it working once a field is updated.

Thanks in advance.