Zip+4

L

Lynn

In Office XP - I'm merging from Excel to Word. All Zip+4 zip codes only print "0", not full zip code. Excel cells are formatted for Zip+4. Also tried formatting as Zip Code or Text.
 
A

Alison

See below. There is another person with this same issue and there is an answer following. It's under Zip Codes, Keith. Hope that helps.
 
G

Graham Mayor

Lynn said:
In Office XP - I'm merging from Excel to Word. All Zip+4 zip codes
only print "0", not full zip code. Excel cells are formatted for
Zip+4. Also tried formatting as Zip Code or Text.
Click to expand...

See
http://www.gmayor.com/formatting_word_fields.htm
and
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
esp the section on Excel data

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

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

Format Zip Codes in Excel for a Mailmerge 2
Zip plus 4 not working in label mail merge 2
Zip Codes 1
Mail Merge and Zip+4 1
Zip Codes 0
Office 2007 Mail Merge Zip Code 1
Mail merge prints zip as 0 instead of correct code 3
Zip Code formatting Problem Word 2007 5

Top