In this article I will explain the Next Record Field of Mail Merge. The Next Record Field can be used to display multiple records in one document.
What is it?
Consider the letter below:
The letter consists of 2 greeting lines which belong to 2 separate records. By pressing Alt+F9 you can see the Fields used in this record:
As you can see in the figure above a Next Record Field was used. This field tells all proceeding fields to display information from the next record.
Create the main layout for your document. Create a Recipient List. In this example I will be using the recipient list below:
Insert any Fields the document may need:
Move the cursor to the location you want the Next Record Field to be inserted.
Note: All proceeding records will display data from the next record.
Click on the Rules button on the Mailings Ribbon. Select the Next Record Field:
Note: The Next Record Field is not visible unless you press Alt + F9:
Note: By placing 2 Next Record Fields, 2 records will be skipped by all proceeding fields:
You can download the sample file used in this article from the link below:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com