E-mail

[abcdexcel]

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 o
not-completed).

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

Each department can have many supervisors.

Thanks
NE

 

[Ron de Bruin]

Hi

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

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