ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I set up automatic email when change is made to Excel wrks (https://www.excelbanter.com/excel-worksheet-functions/157620-how-do-i-set-up-automatic-email-when-change-made-excel-wrks.html)

Mr. CSI

How do I set up automatic email when change is made to Excel wrks
 
I would like to be able to have an email sent to me when a change is made to
a Excel worksheet that is shared. How can I do this or can it be done?

FSt1

How do I set up automatic email when change is made to Excel wrks
 
hi.
yes, it can be done. see this site.
http://www.rondebruin.nl/sendmail.htm
scroll down to and click on "mail a small message".
you will have to set up a worksheet change event in the shared workbook. I
personally have never done this but a former coworker told me that he did
something similar.

regards
FSt1

"Mr. CSI" wrote:

I would like to be able to have an email sent to me when a change is made to
a Excel worksheet that is shared. How can I do this or can it be done?



All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com