Can any one help me in creating a macro for sending a mail automatically as soon as a cell is updated in a shared excel.
Range a1:a10, should either have values 0 or 1
Range b1:b10 has associates names
Range c1:c10 has associates mail id's
If any of the cells from range a1:a10 is updated as 1, then it should find the associate who has analyzed it from the range b1:b10 and send out a mail automatically looking at his mail id from C1:C10.
For Example :
I have looked at many templates could not locate an appropriate one.
| ||Posted by vkumarv1982 on |
|There are currently no replies to the "automated email on an event of default" topic of the Excel Help Forum for Automating Data Analysis Tasks.|