I'm trying to use Word Mail Merge to print address labels using only a small segment of a big address list in Excel, which is spread over multiple worksheets.

In the single worksheet I want to use, I have defined a name for the range containing the addresses I want to print labels for, and I've saved that Excel workbook.

The Help file I'm trying to use says:



"In the Microsoft Office Excel dialog box, for Named or Cell Range, select the cell range or worksheet that contains the information that you want to merge, and then click OK."

But when I get to that point in the Mail Merge/Select Recipients part of the process, the Microsoft Office Excel dialog box that shows up only shows me a single alternative: "entire spreadsheet".

Even if I type into that window the name of the range I defined in the Excel file and click OK, I still get labels starting with the very first one in the very first worksheet of the workbook.

What am I doing wrong?