Mail merge with Word and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glen - 05 Jan 2004 20:16 GMT

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.

Reply to this Message

Graham Mayor - 06 Jan 2004 07:07 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> 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.

Reply to this Message

Jeane - 06 Jan 2004 17:54 GMT

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?

>Thank you for any help that you can give me.
>.

Reply to this Message