Resizing Excel for Emailing
 

Hi

In "Sheet1" Range ("A6:L67") on this range there are several merged cells on
different rows always from A:L on which ever row it is.
No problem copying & pasting to "Sheet2" however is it possible to auto
resize the range in "Sheet2" so that it fits to just one page width in
Outlook Express. Is it also possible to add a couple of buttons on "Sheet2"
one which would open Outlook and insert the resized "Sheet2" the other to add
Email addresses in C.c which I could place in cells below the range listed
above.

Any help much appreciated

Cheers---- Mully