MERGEREC

Displays <<MERGEREC>> as a field result. Use this field in a mail merge main document to print the number of the corresponding merged data record in each resulting merged document.



REMARKS
* The number reflects the sequential order of the data records you've selected and possibly sorted for merging with the active main document. It does not indicate the actual order of the records as they occur in the "physical" data source.
* For example, a personnel database in Microsoft Access might contain thousands of records. However, to send a form letter to employees who've reached their five-year anniversary with your company, you'd select as your data source only the records of those five-year employees - a much smaller set of records. To print a "physical" record number, you must include a record number field in the data source and insert the corresponding merge field in the main document.
* The following example uses a MERGEREC field inside an = (Formula) field to create unique invoice numbers. When the main document is merged with the data source, the number resulting from the MERGEREC field is added to the numbers representing the date and time the invoices are printed.
* For the Microsoft documentation refer to support.microsoft.com

Examples

Invoice Number: { = { PRINTDATE \@ "MMddyyHHmm" } + { MERGEREC } } = Invoice Number: 21390946

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top