A colleague asked my help to group multiple row data from an excel database to a word document using Mail Merge. I've managed to do so by following a youtube guide (link posed below*) that relies heavily on NEXT IF sequences. The example output of this in Preview Results 1 is:
"A - Blue
B - Green
C - Yellow"



So far so good but I need to repeat this same list at another point in the same word document with an additional column of information. I copy pasted the same script, added the new column of data to it and it's giving me the following example output in Preview Results 1:
"C - Yellow - London"

While I need it to give me
"A -Blue - Berlin
B - Green - Paris
C - Yellow - London"

It appears that when copy pasting the same script it only outputs the last item in the sequence. I've attached both the word with what I have so far and it's excel database.

Could anyone help me figure out how to separate these two next if sequences?
Thank you in advance!



*Link to youtube video I used for grouping multiple row data: Mail Merge Grouping Multiple row data- NEXTIF - YouTube

Attached Files

	Example_Word.docx (15.7 KB, 33 views)
	Example_Word.xlsx (10.8 KB, 25 views)