PDA

View Full Version : Help with a VBA code Please to send emails out of access



TonyC
2016-05-17, 07:57 PM
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