View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default ".0" added to zip code in Word 2003

Fix it with a numeric switch on the merge field \# "00000"
See the zip section of 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



wrote:
I'm using Word 2003, and for some reason, when mail merging with an
Excel database file, Word will add ".0" to the zip code, resulting in
something like this:

Mr. Melvin M Person
1710 Alder Creek Ct
San Jose, CA 95148.0 (note the extraneous 0)

I'm out of my mind trying to figure this problem out. This hasn't
happened until recently.