View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Zip codes starting with 0 in Mail Merge

See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


chris76 wrote:
I'm using an Excel Worksheet and Word Mail Merge for envelopes. NJ
zips start with zero and mail merge won't accept these as a valid 5
digit number. I've formatted the cells in Excel as special/zip code,
text, and number, but mail merge only returns a 0 and drops the other
four digits.

Does anyone know how I can get mail merge and excel to accept 5 digit
zips starting with zero as valid text?

Word and Excel professional edition 2003