I have created custom labels which contain formatting (borders) and static text. There is only one mail merge field in each label. There are three labels per page. When I do the mail merge with the source file (an Excel file) it takes each record in the source file and populates this value into the mail merge field in each of the labels on the page.

What I want it to do is take the first record, populate the value of the mail merge field for that record into the first label on the page then move to the second record and populate the value of the mail merge field into the second label on the page and move to the third record and populate the value of the mail merge field into the third label on the page then move to the four record and populate the value of the mail merge field into the first label on the second page of custom labels, etc. etc.



Rather than do this it is repeating the value of the mail merge field in each record three times on each page.

How can I get it to populate one value from the source file onto one label and then move on through the list of records in the source file?