word mail merge zip +4 replaced with "0"

[carolynk]

Office 2003: when creating labels via mail merge from an excel file. the
zipcode fields (containing a mix of 5-digit zipcodes and zip+4s) are merging
as "0" when the field contains zip+4 data. huh? Did not have this problem in
Office 2000.

 

[Graham Mayor]

See the relevant section of http://www.gmayor.com/formatting_word_fields.htm
and/or the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[carolynk]

thanks - I actually had found your solution/instructions after I posted my
question - very clear & much appreciated!