Dear Experts,
This report has more than a thousand entries, but i picked an example to show you.
I have hundreds of employee managers that need to be aware that their reps have no targets , but instead of having to contact each via outlook manually I need a VBA code to email via macro. Please see attached sheet for illustration.
1- I need for the (Supv Name) column to be filtered under each supervisor which in return filters for the applicable data related to each supervisor just as shown on the sheet – for EMP ID, name, Action , etc..
2- And once the superviser name is filtered with its corresponding data, I need it to be emailed (outlook)to that supervisor email listed under (supvEmail) column.
Thank you very much for your help
Tony
This report has more than a thousand entries, but i picked an example to show you.
I have hundreds of employee managers that need to be aware that their reps have no targets , but instead of having to contact each via outlook manually I need a VBA code to email via macro. Please see attached sheet for illustration.
1- I need for the (Supv Name) column to be filtered under each supervisor which in return filters for the applicable data related to each supervisor just as shown on the sheet – for EMP ID, name, Action , etc..
2- And once the superviser name is filtered with its corresponding data, I need it to be emailed (outlook)to that supervisor email listed under (supvEmail) column.
Thank you very much for your help
Tony