Automated email on an event of default

Excel Help for automated email on an event of default in Automating Data Analysis Tasks

Find Excel Solutions

Search the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

Home > Forum Home > Automating Data Analysis Tasks > automated email on an event of default

Forum Topic

Reply Login

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.

Reply

Find relevant Excel templates and add-ins for automated email on an event of default in the Excel Business Solutions Directory

Find Excel templates
and add-ins in the
Excel Business Solutions Directory