email specific values to specific people in spreadsheet using macro

[seancm]

Hi All
I relativly new to macros

I have been looking for a macro that does the following

I have a workbook with 2 sheets

sheet 1 is a list of meetings for the week by our reps
Column a is the reps name
Column b is who they met
Column c is the date they met
Column d is when they met
Column e is the duration of the meeting in other words how long it was
Column f is their supervisor's name

Sheet 2 is a table of supervisors and associated emails


I need a vba script that says if a supervisors name appears on sheet 1 column d
then generate an email to that supervisor using the table in sheet 2

in the body of that email

list all associate rep names with associated values

example:

(rep name1) "met with" (Who) "on" (Date) "at" (when)" for" (duration)
(rep name2) "met with" (Who) "on" (Date) "at" (when)" for" (duration)

and so on..

for each supervisor

can anyone help me with this

 

[seancm]

clarification some reps are temp hires and do not have a supervisor listed I want to skip these