".0" added to zip code in Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ashwooddayton@gmail.com - 08 Jul 2007 06:12 GMT

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.

Reply to this Message

Graham Mayor - 08 Jul 2007 06:57 GMT

Fix it with a numeric switch on the merge field \# "00000"
See the zip section of http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> 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
[quoted text clipped - 6 lines]
> I'm out of my mind trying to figure this problem out. This hasn't
> happened until recently.

Reply to this Message

ashwooddayton@gmail.com - 08 Jul 2007 17:26 GMT

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.

> Fix it with a numeric switch on the merge field \# "00000"
> See the zip section ofhttp://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Reply to this Message

Graham Mayor - 09 Jul 2007 07:10 GMT

Unfortunately you cannot do this with the addressblock field. The
addressblock field is fine when it works, but it doesn't always work (though
it seems better in Word 2007 than in earlier versions) Instead of using this
field, insert the individual fields that make up the address in the layout
you require them.
See also http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm which cover general
mail merge issues.

Signature

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

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

> After toggling the field codes, I get this for the address block:
>
[quoted text clipped - 30 lines]
>>
>> - Show quoted text -

Reply to this Message

Rate this thread: