Help with a VBA code Please to send emails out of access

TonyC

New member
Joined
May 13, 2016
Messages
2
Reaction score
0
Points
0
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
 

Attachments

  • 03a-NewPositionNoTargets.xlsx
    22.8 KB · Views: 15
Top