Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Help (Word 2002)

    I have XP, I have formatted excel, chosen special, to include a first digit zero in a zip code but it will not merge the same in my letters or labels. I have played with it on a couple of label templates and it merges correctly, I managed to inadvertently do something right when setting it up but don't know what that was and can't seem to do the same for others. Could you please help me so I don't have to go back and insert the zero each time before I print, if I forget, the zip codes are incomplete.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Mail Merge Help (Word 2002)

    Hi,

    One way of dealing with this is to use a numeric picture switch on the mergefield to force the appearance of leading zeros. For example, if you need a 5-digit code, put:
    # 00000
    in the field, after the fieldname.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •