Mail merge address labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

issy1020 - 26 Aug 2006 04:05 GMT

Hi, I am trying to create address labels. There is a problem with the zip
code. My data source is an excel template. When I merge the data, the zip
code shows the 5 digit zip code with a .0 after it. Example - 11111 shows up
as 11111.0 I tried changing the format to text formatting, but that did not
work. Thanks!

Reply to this Message

Doug Robbins - Word MVP - 26 Aug 2006 06:51 GMT

See the following page of fellow MVP Graham Mayor's website:

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi, I am trying to create address labels. There is a problem with the zip
> code. My data source is an excel template. When I merge the data, the zip
[quoted text clipped - 3 lines]
> not
> work. Thanks!

Reply to this Message

Graham Mayor - 26 Aug 2006 06:54 GMT

See the relevant section at 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi, I am trying to create address labels. There is a problem with the
> zip code. My data source is an excel template. When I merge the data,
> the zip code shows the 5 digit zip code with a .0 after it. Example -
> 11111 shows up as 11111.0 I tried changing the format to text
> formatting, but that did not work. Thanks!

Reply to this Message