Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Portland, Maine, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ZIP code zero suppress in mail merge (XP)

    We have a problem creating mailing labels using mail merge. The problem is that most Maine zip codes begin with zero and the address block seems to be zero-suppressing on the zip field so that 04102 prints as 4102. The data source is an Excel XP worksheet with the ZIP column formatted as Custom - ZIP.

    Is there a way to force the ZIP in the address block to print all 5 digits?

    Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ZIP code zero suppress in mail merge (XP)

    Glenn,
    I don't have XP, but if the Excel data is formatted as Zip, then it should work as with my office 2000.
    Otherwise try adding formatting to the mergefield for the zip code: { MERGEFIELD Zip # 00000 }

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Location
    Portland, Maine, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ZIP code zero suppress in mail merge (XP)

    Gee - another Mainer on the list!

    Unfortunately, I'm troubleshooting this for our church secretary and I don't have access to Word XP to test from here, but I don' t recall seeing a mergefield called ZIP when the merge is being done as <<address block>>. Also, if I try to do the merge as single fields, there seem to be only 4 format commands available for the mergefield (insert before, ???).

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ZIP code zero suppress in mail merge (XP)

    Glenn,
    Yes, another recent Mainer, only 90 mi north of you.

    Did some research and came up with a known issue.
    See: click here

  5. #5
    New Lounger
    Join Date
    Oct 2002
    Location
    Portland, Maine, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ZIP code zero suppress in mail merge (XP)

    Looks like just the ticket!

    Thanks!

Posting Permissions

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