PrintArea does not show up in Mail Merge

[Pixel Warrior]

I am trying to only print a print area. I have two worksheets on my linked
Excel spreadsheet. I filtered the first sheet, set the print area, and used
Mail Merge to print out only the labels I wanted. This worked fine. But on
the second sheet, I have set the print area as before but now I only get the
option for Entire Spreadsheet or _FilterDatabase. I removed all of the
filters (there were a couple of Auto Filters on) but still the same story. I
even copied and pasted both worksheets into a new spreadsheet but still
can't get back the PrintArea option. When I click on Merge to Printer, the
entire first sheet is printed and it ignores the set PrintArea on the second
worksheet.
Word and Excel 2000

 

[Peter Jamieson]

At the moment it looks as if you are using DDE to connect to Excel - in that
case, Word can only see the first sheet in a workbook. If you can use ODBC
or OLEDB (Word 2002/2003 only), or even the Excel converter (gone in Word
2003 I think) then you may be able to see the range you want to use. Word
2002/2003 use OLEDB by default, but you can see the options in Select Data
Source by checking Word Tools|Options|General|Confirm conversion at open; in
Word 2000//97 you need to check the "Select method" box in Open Data Source
to see the options. But generally speaking, what Word can see is /sheets/
and /named ranges/ - if setting the print area sets a named range, you have
some chance of referring to it. In addition, using some connection methods
you can specify a range using R1C1:RnCn format or A1:Mn format (I forget
which).

Peter Jamieson