How can I email an Excel print area?

I have an Excel spreadsheet and I want to email the "print area" only,
not the entire sheet. This area is for viewing only, not editing. Do
you know how I can do this? I'm stuck.
Thanks,
Russell

Hi

Take a look at Ron de Bruin's site. I'm pretty sure his addin has a facility
to send a selection.
http://www.rondebruin.nl/mail/add-in.htm

Regards

Roger Govier


russell wrote:
> I have an Excel spreadsheet and I want to email the "print area" only,
> not the entire sheet. This area is for viewing only, not editing. Do
> you know how I can do this? I'm stuck.
> Thanks,
> Russell
>

Hi Russell

I have examples on my site for this
Add a line to select the printarea and you are done
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"russell" <russell1256@hotmail.com> wrote in message news:1131378789.728277.228050@g47g2000cwa.googlegroups.com...
>I have an Excel spreadsheet and I want to email the "print area" only,
> not the entire sheet. This area is for viewing only, not editing. Do
> you know how I can do this? I'm stuck.
> Thanks,
> Russell
>