Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge 5 & 9 digit Postal codes (2002 - XP)

    I am trying to do a mail merge using an Excel file as the data source. One of the fields is a Postal code which contains both 5 digit (#####) and 9 digit (#####-####) codes. Problem is, when I merge the data, the 9 digit Postal codes appear as

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge 5 & 9 digit Postal codes (2002 - XP)

    Hi Don:
    The method in the article should work. Can you copy the field codes that you're using so we can actually see them? By the way, did you update the codes (F9)?

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge 5 & 9 digit Postal codes (2002 - XP)

    Okay, I was wrong... it DOES work. I was creating a field code (Ctrl F-9) then copying and pasting everything in between the braces. I didn't realize they were nested field codes. Anyway, when I typed it in, it worked fine.

    Interestingly, I also found that the original data source and merge document also works fine provided the first record is in the #####-#### (9 Digit) format. It is as if Word established the field picture based on the first record.

    Thank you for your help.

Posting Permissions

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