Creating a Mail Merge Template for Labels

  1. Open Microsoft Word, and based on your version, locate the Mail Merge feature.

Microsoft Office 2010

Go to the Mail Merge tab and select Labels.

Microsoft Office 2003

Go to the Tools menu and select Letters and Mailings, Mail Merge.

Note: Follow the Mail Merge Wizard that appears on the right side of the document to select Labels.

  1. Select the Label product (Example: Avery 5162).

  1. Create a new document that displays the labels template. Leave this document open in MS Word.

  1. Open Morningstar Office and navigate to the Client Management tab and then the Mail Merges page.

  2. From the toolbar menu above the grid, select New, Document Template.

  3. Enter the Merge Template Name and Merge Template Description.

  4. Select the variables from the template that you would like to include in your address labels. Leave the template open and return to MS Word.

Note: Variables are encapsulated with double arrowheads << >>..

  1. Copy and paste the address Variables into the MS Word labels template. Continue to copy on multiple pages until you have entered enough cells to create labels for your entire mail merge.

Note: To save time paste variables in each cell of the first page, and copy and paste the entire page.

  1. Upon completion, click CTRL+A to select all MS Word content, and then click CTRL+C to copy all selected content.

  2. Return to Morningstar Office and delete all content in the existing template.

  3. Click CTRL+V to copy the labels from the MS Word template into this Merge Template.

  4. If necessary, use the Page Setup button to reset the margins of the Merge Template to match those of the Microsoft Word document.

  5. Click Save and then Close. The labels template is now available for mail merges.