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

Attached Files

Sample spreadsheet.xlsx (8.7 KB, 12 views)