View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default automatically send email from excel

I want to automatically send an email from excel when a certain value within
a cell is reached. Does anyone have a macro template to do this?? I have
other users accessing a common spreadsheet on a shared server and if they
enter data into this spreadsheet that causes a certain cell to hit a
predefined watermark that I have already setup, then I want to be able to
have excel automatically send an email to me alerting me that this watermark
or cell value has been reached.

I have already added Ron de Bruin's Excel "send email" add-in if this is
required.

Thanks.