Mail Merge Directory - Creating merge with multiple lines

[tiggynook]

Not sure if this belongs in another section or if it has been answered, if it has please link me.

I am trying to create a mail merge with multiple lines and everything I am reading says to use the mail merge set up as a directory but it is still pulling all lines of data into individual letters.

I have 3 columns: Name, Section Chair, Results.
I want a letter addressed to each Section Chair with the list of names and results. Some Section chairs have 1 line, some have 2, 3, 4, 5, and so on. How do I set up the mail merge to include all the information for each section chair in one letter.

I want it to look like this:

Dear "Section Chair",

"Name - Results"
"Name - Results"

Thanks in advance!

[dflak]

You will have to "unnormalize" the data to make it work with mail merge. That is, you have to string it out like this.

Then in the mail merge you can have fields like

Please Login or Register  to view this content.

There is an option in Word mail merge to not print blank data, so if you don't have a Chair5 and Res5, they won't print. I just thought of something - because of the dash, the line will print, so you can combine them into a single entity containing the dash.

To convert from what you have to the strung out format will take some VBA code. If you are interested, you will need to provide a sample workbook.

The pictures below show your data format and the format the data needs to be in.

[tiggynook]

This is what I was trying to avoid. I do not want to manipulate the data.

I found instructions online on how to do what I need using the mail merge as a directory using codes in the merge fields but I don't understand code and it isn't working properly.

I am attaching an image of the code I was given to write into the word document, but like I said it is not working and I don't understand it to fix it.

Capture.PNG

[dflak]

In that case, I suggest you ask the question in the Word forum. I've found Word fields to be confusing at best.