Hi

In column A, I have got name of the employees.
In column B, their department.
In column C, their supervisor's name.
In column D, supervisor's e-mail ID.
In column E, Head of the department (HOD).
In column F, HOD's e-mail ID
In column G, status of employee's work (whether completed or
not-completed).

A macro, which automatically sends e-mail to all employee's supervisor
whose work is "not-completed". Also, CC to the HOD. One e-mail to each
supervisor containing the list of employees under him.

Each department can have many supervisors.

Thanks
NEU


--
abcdexcel
------------------------------------------------------------------------
abcdexcel's Profile: http://www.excelforum.com/member.php...o&userid=30021
View this thread: http://www.excelforum.com/showthread...hreadid=497861