Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merging from second spreadsheet of Excel Workbook (2000)

    Hello everyone,

    Can someone give me advice on how to pull information from Sheet 2 of an Excel spreadsheet into a Word document using mail merge? I can't seem to figure it out.

    Thanks.

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

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    It may help if you give the data source range on Sheet 2 a name in Excel: select the range, and type the name in the cell address box in the formula bar.
    In Word, check "Confirm conversion on open" in the General tab of Tools | Options...
    Now, when you select the data source for the mail merge, you should get several options. Experiment with them, and look out for dropdown lists and Options buttons in the dialog that appears. I can't give you more specific information, for I use Windows XP, and the mail merge process has changed considerably.

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    Thanks for that advice. I tried that, but I still couldn't get it to work, it still only pops up two options: Entire spreadsheet or _Filter Database.

    Any other ideas?

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

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    Let's hope that someone with Word 2000 will react. I can't believe that this would be impossible in Word 2000.

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

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    The search facility isn't available right now, but the problem stems from how you do your merge. Basically, you can't use DDE (Dynamic Data Exchange) to merge something that's not on the first worksheet. Take a look at the second two methods in <post#=128577>post 128577</post#>. These use a converter or OBDC (Open Database Connectivity).
    Hope this helps,

  6. #6
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    This may be a dumb suggestion (as I know very little about merge) but could you:

    - Open the workbook in Excel.
    - Move the second worksheet so that it is the first. Save and close the workbook.
    - Do the merge from Word.
    - Reopen the workbook in Excel and move the worksheet back to second place.

    Gary

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    When you ask Word to open your data source, there is a checkbox labelled "select method" beside the "files of type" dropdown list. Put a check in this box. The next screen that comes up gives you a choice of data sources and it probably has "MS Excel Worksheets via DDE" already selected. If instead you select "Microsoft Excel via Converter", the next dialog box gives you a choice of "Entire Worksheet" as well as the names of the individual sheets. Good luck. The attached .doc file shows some pretty ugly screenshots from a demo.
    Attached Files Attached Files

  8. #8
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merging from second spreadsheet of Excel Workbook (2000)

    YOU ROCK! That worked perfectly! Thank you so much, what an exciting beginning to my Monday!

Posting Permissions

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