Excel provides a Special number format for zipcodes which allows those of us in New England to display our zipcodes properly. However, when you do a mail merge in Word 2002 and 2003, this formatting will not come through. A zipcode of 01040 will display as 1040. You can fix this in Excel by converting the number back to text, but if your list is extensive, you won’t want to do this. This tip will show you how to display 5-digit zipcodes properly in a Word mail merge without having to reformat your data.

After you create the merge document and attach your Excel workbook containing the addresses:

1. Insert the merge field for your zip code where you want it.

2. Press ALT+F9 to display the field codes. The Zip code field will look something like this (the text in quotes will be the name of your zip code field). Ignore any shading that might appear.

{ MERGEFIELD “Zip_code” }

3. Change the field to include a number format, as shown below. Make sure to place it inside the curly braces and include the spaces, etc. Make sure to use a backslash \ and not a forward slash /. Note that the number format is enclosed in quotes (“):

{ MERGEFIELD “Zip_code” \# “00000″ }

4. Press ALT+F9 again and preview the merge.

5. You may have to update the field by selecting it and pressing F9 in order to see the results of your change.