Mail Merge adding decimal and zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drgree - 02 Mar 2004 02:06 GMT

Can anyone tell me why Mail Merge (I have MS Millenium) adds a decimal and then a zero to the end of all my zip codes when it merges the data? The database is an Excel spreadsheet, and the Postal Code field was first formatted as a general number, then changed to 'text' - but it still adds the decimal and zero. Why?

Reply to this Message

macropod - 02 Mar 2004 06:01 GMT

Hi,

Easily enough fixed:

1. Select the errant field and press Shift-F9.
2. After your mergefield reference, but before the \* MERGEFORMAT switch
(if it's there), add: \# "00000" (Change the number of 0s to match your zip
code length). Your field should now look something like { MERGEFIELD Data \#
"00000"} or { MERGEFIELD Data \# "00000" \* MERGEFORMAT }.
3. Press F9 to update.

Cheers

> Can anyone tell me why Mail Merge (I have MS Millenium) adds a decimal and then a zero to the end of all my zip codes when it merges the data? The

database is an Excel spreadsheet, and the Postal Code field was first
formatted as a general number, then changed to 'text' - but it still adds
the decimal and zero. Why?

Reply to this Message

Graham Mayor - 02 Mar 2004 06:22 GMT

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

Signature

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Can anyone tell me why Mail Merge (I have MS Millenium) adds a
> decimal and then a zero to the end of all my zip codes when it merges
> the data? The database is an Excel spreadsheet, and the Postal Code
> field was first formatted as a general number, then changed to 'text'
> - but it still adds the decimal and zero. Why?

Reply to this Message