Skip to main content

Customize Quote Templates using Word Mail Merge

Zuora

Customize Quote Templates using Word Mail Merge

This article explains how to create a custom quote template using the Microsoft Mail Merge feature and covers the mail merge features that apply to quote templates. For more specific information about Mail Merge, refer to the Microsoft Office Word documentation. Also, if you are using a version of Word that this article does not cover, refer to the Microsoft Office Word documentation for the exact steps to work with the Mail Merge features.

You are able to use up to 500 unique merge fields on a single quote template. The time to generate a quote PDF/document is proportionate to the amount of merge fields on the quote template. 

Insert a Mail Merge Field in a Quote Template

You can create a custom billing document template using the Microsoft Mail Merge feature, as well as insert mail merge fields to a template and customize the format, and use the mail merge tables to add multiple line items to a template.

Insert a Mail Merge field in Microsoft Word 2007 and Word 2010

To insert a mail merge field in your template in Word 2007 and 2010, complete the following steps:

  1. In Word, click Insert > Quick Parts > Field.
  2. In the Field dialog box, click Categories and select Mail Merge.
  3. In the Field names field, click MergeField.
  4. In the Field Name field, enter the name of the merge field that you want to insert, for example, Account.Name. The merge field is inserted in your document. For example, if you added the account name, Account.Name, in the document, the field will be displayed as: «Account.Name». See Supported Merge Fields for a list of available merge fields. 
    MergeFieldName.png
  5. Click OK.
  6. Save the template file as the Word 97-2003 Document (.doc) type.

Insert a Mail Merge field in Microsoft Word 1997 to Word 2003

To insert a mail merge field in your template in Word 1997 to Word 2003, complete the following steps:

  1. In Word, navigate to Insert > Field.
  2. In the Field dialog box, click the Categories arrow and select Mail Merge.
  3. In the Field names field, click MergeField.
  4. In the Field name field, enter the name of the merge field that you want to insert, e.g. Account.Name. The merge field is inserted in your document. For example, if you added the account name, Account.Name, in the document, the field will be displayed as:  
    «Account.Name»
  5. Click OK.

Insert a Merge Field in Word for Mac

To insert a mail merge field in your template in Word for Mac, complete the following steps:

  1. In the Macintosh Word, navigate to Insert > Field.
  2. Click the Categories arrow and select Mail Merge.
  3. In the Field names field, click MergeField.
  4. In the Field codes field, enter a space after "MERGEFIELD" then type the field name you want to insert, e.g. Account.Name. For example, if you have " MERGEFIELD Account.Name" in the Field codes field, in the document, the field will be displayed as: 
    «Account.Name»
  5. Click OK.
  6. Save the file in the Word 97-2004 Document (.doc) format.

Edit a Mail Merge Field in a Quote Template

To update a merge field using Edit Field on Windows, complete the following steps:

  1. In your template document, right-click on the merge field you want to edit and select Edit Field.
  2. In the Field name field, enter the new merge field name.
  3. Click OK.

To update a merge field using Toggle Field Codes on Windows and Mac, complete the following steps:

  1. In your template document, click the merge field you want to edit.
  2. Toggle the field code and result:
    • Press ShiftF9 on Windows.
    • Press option + fn + F9 on Mac.
  3. Edit the field name in the field code.
  4. Update the field:
    • Press F9 on Windows.
    • Press option + fn + F9 on Mac.
  5. Repeat Step 2 to verify that your change has been saved.

You cannot change a merge field by simply typing a new merge field over the current field.