Publisher mail merge next record
A classic request!
In a publisher mail merge, "Next Record" is a special field that allows you to move to the next record in the data source when you click on it. This is useful when you want to preview or print a large number of documents, one at a time.
Here's how to use "Next Record" in a publisher mail merge:
- Open your Publisher document and go to the "Mailings" tab in the ribbon.
- Click on the "Select Recipients" button and choose your data source (e.g., an Excel spreadsheet or a database).
- In your document, place your cursor where you want to insert the next record.
- Go to the "Insert" tab in the ribbon and click on "Field" > "More Fields".
- In the "Field Names" dialog box, scroll down and select "Next Record".
- Click "OK" to insert the field.
- When you click on the "Next Record" field, Publisher will move to the next record in your data source and update the fields in your document accordingly.
Tips:
- You can use "Next Record" multiple times in your document to move to the next record each time you click on it.
- If you want to move to the previous record, you can use the "Previous Record" field instead.
- You can also use other special fields like "Record Number" to display the current record number or "Record Count" to display the total number of records in your data source.