zip codes starting with 0

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top