Mail Merge adding decimal and zero

[drgree]

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?

 

[macropod]

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?

 

[Graham Mayor]

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


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

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