Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Toronto, Ontario, Canada
    Thanked 0 Times in 0 Posts

    Mail Merge to Word (2000)

    I have an Excel spreadsheet and I am attempting to merge various fields on sheet 2 - into a Word 2000 document. When I do the mail merge - I should be getting an option to choose the worksheet that I want to merge from. (This is the case in XP) What I do get is an option to merge the entire worksheet and nothing else. It then only allows me to merge the data in worksheet 1.

    Any ideas on why this is?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Mail Merge to Word (2000)

    If you use DDE, you can only "see" the first worksheet in the workbook, unless the workbook is open to another worksheet in Excel when you initiate the mail merge. To use other methods, make sure that "Select Method" is checked in the Open Data Source dialog.

    See MSKB article HOW TO: Use an Excel Data Source for Mail Merge in Word 2000 for details.

Posting Permissions

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