Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merging one worksheet from several in Excel (Word 2000)

    What is the correct syntax to pull only one worksheet from several worksheets in an Excel spreadsheet when performing a mail merge. When I walk through the 3 steps to mail merge and choose an Excel spreadsheet as my data source, the only option that I get is "Entire Spreadsheet" but I know there must be some way to type and specify only one tab on said spreadsheet. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail merging one worksheet from several in Excel (Word 2000)

    Select Tools | Options..., and activate the General tab. Tick the box labeled "Confirm conversion at Open", then click OK.

    When you select an Excel workbook in step 2 of the Mail Merge Wizard, you will be asked how the workbook should be opened. In Word 2000, you get three options, I believe:
    - Excel via DDE
    - Excel via Conversion
    - Excel via ODBC

    DDE (the default choice) by default uses the first worksheet in the workbook. "Entire spreadsheet" means this first worksheet. If you have named ranges in your workbook, you can select those too.

    The other two options let you select which worksheet you want to use. With ODBC, you have to click Options... and tick all the check boxes to see the list.

    Note: the ODBC option has the annoying habit of selecting another workbook than you selected; you may have to reselect it from the dropdown list in the dialog.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merging one worksheet from several in Excel (Word 2000)

    Thanks Hans, for the prompt reply. When I choose Open Data Source, select the .xls file, I automatically get the window that pops up with Entire Worksheet as the only option to choose. I don't get the choice of "via DDE...via Conversion...via ODBC" Is there some setting/option that I might have different that yours.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail merging one worksheet from several in Excel (Word 2000)

    Did you set the "Confirm conversion at Open" option? I don't have Word 2000, but it is the setting that makes the choice pop up in Word 2002, and I'm pretty sure it worked that way in Word 97 too.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merging one worksheet from several in Excel (Word 2000)

    Well - I turned that on, but it did not seem to make a difference. It's still jumping straight to the DDE options with "Entire Spreadsheet" showing. Anything in Compatibility that might make a difference? If you can't think of anything don't worry - I can always work around the problem by switching the order of the worksheets. I just hate when you know the software can do something, but can't get it to do it.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail merging one worksheet from several in Excel (Word 2000)

    I was going to suggest switching the order of the worksheets as a workaround too. Perhaps somebody else will offer an insight in the cause of this behavior.

  7. #7
    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 merging one worksheet from several in Excel (Word 2000)

    Hi Satiria:
    Hans is correct, but he left out one step. (That's what happens after awhile when you start using a new version. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) When you use the Wizard to open your data source (Step 2), you will see a box near the lower right corner of the Open Data Source dialog box named Select. You must check that box. Then you will get the choices that Hans mentioned.
    Hope this helps,

  8. #8
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merging one worksheet from several in Excel (Word 2000)

    Cool, cool, cool. Yes, if I check the Select Method box on the Open Data Source window, then I get that nice Confirm Data Source window asking me which way to convert (via DDE, via ODBC, etc.). Thank you both so much for your help on this!

    -Sat

Posting Permissions

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