Instructions for Mail Merge field codes are not too clear and I have been stuck at this for days and have gotten nowhere. Here's what I am trying to do:

With the Excel file I am using for this Mail Merge, there are multiple values on different rows, that I'd like to appear on one page.

The key field here is the 'No.' and every row will have this field, along with the 'description' on it.

You can see the description field on the word document.

What I would like to happen is for the document to keep looping through each row, inserting all of the descriptions on the same page, as long as the 'No.' is the same.

The pseudo code would be:

IF No. is the same, loop through, else, start a new page.

I tried using this video to help me, but I can't quite implement it:
https://www.youtube.com/watch?v=4Ck8KAwAQso

I am new to this and I've tried to code this myself, but have gotten nowhere.

Documents are attached.

If anyone could help me with this, I would greatly appreciate it.

Thanks

Attached Files

	dummy-document.docx (15.2 KB, 21 views)
	dummy-excel.xlsx (9.0 KB, 24 views)