How can I email an Excel print area?

[russell]

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

 

[Roger Govier]

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

 

[Ron de Bruin]

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