I have the data below in Excel format (also attached). I want to send one email to Ralph, one email to Mary, one email to Jack, and one email to Tina. Each email has to include a table or list that tells each employee their Rating for each of their Tasks. As you can see, not every employee has the same Tasks or same number of Tasks. It's important that each employee receive only a single email.
Sorry if this has already been answered, but I could not find a thread that was exactly on point. Thanks!
Recipient Email Your Tasks Your Rating
Ralph
ralph@company.com Tooth brushing 4
Ralph
ralph@company.com Car washing 5
Ralph
ralph@company.com Lawn mowing 2
Ralph
ralph@company.com Pie eating 3
Ralph
ralph@company.com Nose picking 5
Mary
mary@company.com Car washing 5
Mary
mary@company.com Fence jumping 1
Jack
jack@company.com Letter typing 5
Jack
jack@company.com Pie eating 3
Jack
jack@company.com Tooth brushing 1
Tina
tina@company.com Car washing 4
Tina
tina@company.com Fence jumping 4
Tina
tina@company.com Tooth brushing 3
Tina
tina@company.com Nose picking 5