View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] ashwooddayton@gmail.com is offline
external usenet poster
 
Posts: 2
Default ".0" added to zip code in Word 2003

After toggling the field codes, I get this for the address block:

{ ADDRESSBLOCK \f "_TITLE0__FIRST0__LAST0__SUFFIX0 _
_STREET1__STREET2__CITY__STATE__ POSTAL_
_COUNTRY_" \l 1033 \c 2 \e "United States" \d }

I've looked at the link you gave, but it deals with "MERGEFIELD", and
after trying the numeric switch, the zip code wouldn't appear at all.


On Jul 7, 10:57 pm, "Graham Mayor" wrote:
Fix it with a numeric switch on the merge field \# "00000"
See the zip section ofhttp://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://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.- Hide quoted text -


- Show quoted text -