• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

Mail Merge - Selecting Specfic WorkSheet

We are doing a mail merge in 2010

When we specify the data format MS Excel Worksheets via DDE (*.xls) -  we no long get the list to select which worksheet we should pull the data from. Our options are
Entire Spreadsheet or Print Area.... both relating to the first worksheet in the spreadsheet.

I tried to manually enter the specific worksheet name '3Final-Worksheet$'

but that did not work....so how do I get it to look at different worksheets within the spreadsheet.

Thanks - Scott
0
sparkis
Asked:
sparkis
  • 3
1 Solution
 
sparkisAuthor Commented:
I found this -

Select Method Notes:

Excel files via ODBC: Named ranges are displayed by default. To specify a worksheet, click Options and select System Tables.

Where are these options?
0
 
aikimarkCommented:
is your source worksheet in the older .xls format or have you updated it to .xlsx?
0
 
sparkisAuthor Commented:
it was created as xlsx - never xls

there must have been corruption within the ss itself. I created a copy of all work sheets in a new ss and all is well.
0
 
sparkisAuthor Commented:
this was the resolution
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now