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

Hi

Start here
http://www.rondebruin.nl/sendmail.htm

you can change this one
http://www.rondebruin.nl/mail/folder3/message.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"abcdexcel" wrote in message
...

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