Hi,
I have an Excel list of people who are interested in more than one course. For every course they are interested in, there's a row with name, address, course name...
f.e Person x is interested in courses 1, 2 and 3. (so there are 3 rows for person x)
Person y is interested in courses 2 and 4 . (so there are 2 rows for person y)
Now I want to send letters to person x and y, using merge fields in Word. Is there a possibility to get the following result in the letter:
Dear person x,
You are interested in following the following courses: <<merged field, summarizing the 3 courses mentioned before>>
AND
Dear person y,
You are interested in following the following courses: <<
merged field, summarizing the 2 courses mentioned before>>
etc.
Anyone an idea on how to do that? The goal is not to print 3 letters for person x, but only one containing the 3 courses.
Thanks!
Tommy