PrintArea does not show up in Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pixel Warrior - 01 Aug 2005 08:43 GMT

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

Reply to this Message

Peter Jamieson - 01 Aug 2005 14:14 GMT

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

>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
[quoted text clipped - 11 lines]
> worksheet.
> Word and Excel 2000

Reply to this Message

Rate this thread: