Automated email on an event of default

Excel Help for Automated Email On An Event Of Default in Automating Data Analysis Tasks

Automated Email On An Event Of Default

Rate this: (3/5 from 1 vote)

	Hi, 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. For example: 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 : Task Name Mail ID 0 Hari [email protected] 0 Veeru [email protected] 0 Santhu [email protected] 0 Raghu [email protected] 1 Sunil [email protected] 0 Sateesh [email protected] 0 Prakash [email protected] 0 Mahesh [email protected] 1 Nitin [email protected] 1 Chintu [email protected]   I have looked at many templates could not locate an appropriate one. Regards, Vimal
	vimal
	Posted by vkumarv1982 on 21 Apr 2009

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. Post Reply