E-mail

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top