Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Word > Fields > Mail Merge > MERGEREC

 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.

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

     Fields - M | Index - M | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top