Mail Merge - Multiple Rows to Single Email Address

[alfawex]

Hi All. Very much a novice when it comes to mail merging. I've got a data set which consists of individuals who are overdue completing a training course and their line managers email addresses. Instead of line managers getting multiple email addresses where they have more than one report that is overdue completing the training i'd like to be able to have them receive an email with all of their reports in one.

Sample data:

Employee Name	Line Manager
Bob	peter@company.com
Jane	mary@complany.com
John	peter@sompany.com
Joe	peter@company.com
Mary	mary@company.com

Basically, what I want in peter@company.com's instance would be:

Hi Peter,

The following reports of yours are overdue training:
Bob
John
Joe

Any help very much appreciated.

 

[ExceLoki]

you could manipulate your data sheet for the MM to show a list of names for each email. something like this

Book1
	A	B	C	D	E	F
1	Employee Name	Line Manager			Line Mgr	Emp list
2	Bob	peter@company.com			peter@company.com	Bob, John, Joe
3	Jane	mary@company.com			mary@company.com	Jane, Mary
4	John	peter@company.com
5	Joe	peter@company.com
6	Mary	mary@company.com
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=UNIQUE(B2:B6)
F2:F3	F2	=TEXTJOIN(", ",TRUE,FILTER($A$2:$A$6,$B$2:$B$6=B2))
Dynamic array formulas.