Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
issy1020 issy1020 is offline
external usenet poster
 
Posts: 2
Default Mail merge address labels

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!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge address labels

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

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

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

"issy1020" wrote in message
...
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!



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail merge address labels

See the relevant section at http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


issy1020 wrote:
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get mail merge to fill all labels on each sheet? Elizabeth Mailmerge 1 March 24th 06 08:38 AM
Why won't address labels created in mail merge come in centered? Craig Mailmerge 2 February 23rd 06 08:10 PM
30 page mail merge labels only prints one page? Kuda Mailmerge 1 February 9th 06 05:08 AM
I can't get the mail merge to work. It won't apply address to lab troubled and desprate Mailmerge 2 November 27th 05 07:34 AM
Creating mailing labels with the Mail Merge Helper Stephen White New Users 1 April 5th 05 02:25 PM


All times are GMT +1. The time now is 10:11 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"