printing zip codes

[Guest]

I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.

 

[Guest]

Format the column as Text and enter a single quote (apostrophe) before each
entry:

'08759
rather than
08759

 

[Guest]

Will that be a problem for the post office? Do the machines read that? Thanks
for your repsonse!

 

[Guest]

No problem. After pasting into Word, the leading zero is there, but the
leading single quote is gone.

 

[Dave Peterson]

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.