Mail merge with Word and Excel

[Glen]

I am trying to do a mail merge with Word 2000 and Excel 2000. When I do the merge the zip codes all have a decimal point and an extra zero on the end. How do I fix this without having to change each individual record

Thank you for any help that you can give me.

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Jeane]

More than likely you need to format the cells in Excel
where you pull the zip code. I would select the column
and format it as text. That way it won't do any
formatting to the contents.

-----Original Message-----
I am trying to do a mail merge with Word 2000 and Excel

2000. When I do the merge the zip codes all have a decimal
point and an extra zero on the end. How do I fix this
without having to change each individual record?