zip codes starting with 0
 

When doing a mail merge from excel to word zip codes starting with 0 (zero)
drop the first number "0" from the address. ie zip code 01560 prints out as
1560. How do I get all 5 numbers to show?

An Excel way:
Format all your Zip Codes as Text.

A Word way:
Before you start the merge, Tools | Options | General. Place a check next to
Confirm merge at open.
Start the Merge.
When you go to pick the Data Source, a box will pop up. Pick wirksheets via
DDE.

tj

"Joe Mac" wrote:

When doing a mail merge from excel to word zip codes starting with 0 (zero)
drop the first number "0" from the address. ie zip code 01560 prints out as
1560. How do I get all 5 numbers to show?