Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Blues (Word 2000)

    I am trying to run a mail merge to generate a form letter and mailing labels. I used an Excel97 file which I open through Excel 2000. When the merge is run, the comma that is between <<City>> and <<State>> when you set the merge up ends up before <<City>> when the merge is run. Also the <<Zip>> which has data in the Excel file, comes up blank in the completed merge. This happens for both the labels and the form letter.

    Any suggestions out there?

  2. #2
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Mail Merge Blues (Word 2000)

    Any chance that there is a stray delimiter (or two) in your data source?
    Charles Kyle Kenyon
    Madison, Wisconsin

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Blues (Word 2000)

    I'll certainly double check this possibility tomorrow morning, but the same file ran ok five months ago when I last did the merge with word 97 reading an excel 97 file.

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Blues (Word 2000)

    Charles,
    thank you for your assistance. it turns out that it was a problem in office 2000 converting office 97 files. I re-keyed the entire database in excel 2000 and re-typed the form letter and it ran like a charm.

    Douglas

Posting Permissions

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