The "send to as attachment" will send the entire workbook.

"Send to Recipient" will give you the option of attaching entire workbook or
just current sheet as body of email.

To send just the selected range you would need VBA code which is provided by Ron
de Bruin.

http://www.rondebruin.nl/sendmail.htm

If you download his SENDMAIL add-in you will have all the options at your
fingertips.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 10:07:01 -0800, zchuckz
wrote:

Gord, Thanks for responding. On the work sheet "sheet 1" I have 3 sections
that when I print, prints out in 3 pages. I tried the setb printb area as
suggested an it worked great. will this also work when I select "send to
email reciepient as an attachment" as well

"Gord Dibben" wrote:

What do you consider as a "page"?

A range on a worksheet that fits on one printed page?

You could give that range a name then assign it to a print macro or just select
the range and FilePrintSelection.

Or a particular worksheet to print?


Gord Dibben MS Excel MVP


On Tue, 12 Dec 2006 10:00:00 -0800, zchuckz
wrote:

I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.



Gord Dibben MS Excel MVP