Retaining Leading Zeros When Mail Merging from Excel to Word

Retaining Leading Zeros When Mail Merging from Excel to Word

Problem:

I had created an Excel spreadsheet that was being used as a data source for a Microsoft Word mail merge but the Excel document had a field that used field formatting to add leading zeros to the numbers but the numbers were not being imported in to the mail merge document with the leading zeros.

Today’s Challenge?

Retaining leading zeros on a numeric field when using Microsoft Word Mail Merge with an Excel source document.

The Solution

In Microsoft Word…

Change the mail merge field to read…

{ Mergefield ZipCode \# “00000” }

Change “ZipCode” to whatever numeric field you are trying to import / merge.

Leave a Reply