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.
Steps to Add Leading Zeros to Zip Code in MS Word Mail Merge
In Microsoft Word…
- Right click over the Mail Merge Field
- Select “Toggle Field Codes”
- Change the mail merge field code to read, { Mergefield ZipCode \# “00000” }
- Change “ZipCode” to whatever numeric field you are trying to import / merge.
