mail merge

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

I have a list of names and addresses on a spreadsheet. I
am doing a mail merge to print labels through Microsoft
word.
When I do the mail merge, all the 9 digit zip codes appear
as "0". This is in excel and word 2002. I can't seem to
find anything under the more items (like post codes) to
see how the merge will carry over the 9-digit zip code.

Help.
 
Hi

I don't have OfficeXP, so I tested it with Office2000

When the cell format for zip code (123456789) was set to Special.ZipCode,
123456789 was returned by Mail Merge, like it was displayed in cell.
When the cell format was changed to 'Zip Code +4', 12345-6789 was dispayed
as in cell, so by Mail Merge too.
 
Hi Kay,
The easiest way is to convert the zip codes to text before
doing mail merge. On my Mail Merge page
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
you will find a link to
Fix up for 5 digit US zip codes
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5

The fixuszip5 macro will only change number entries not text
entries. Format the column as text first. As text you can
work with zip codes from anywhere in the world (hopefully
Mail Merge won't generate as US Postal Bar code for the
non US zip codes).
 

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

Similar Threads

Leading 0 in Mail Merge document 4
How to merge Excel address columns when some zips begin with zeros 4
Excel database to mail merge 3
nine digit zip code won't print in mail merge 11
only 5 digit zip codes 1
How do I format zip code (9) to use in Word merg doc 1
Changing ZIP code formats in Excel 2003 6
how do I get rid of the green triangle/upper left cell corner 5

Back
Top