E-mail

  • Thread starter Thread starter abcdexcel
  • Start date Start date
A

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
 
Back
Top