Emailing one sheet

[Guest]

I have a client with Excel 2003 and he wants to know if he can email only one
worksheet from a spreadsheet instead of the entire spreadsheet. Only way I
know to do it is lock down the others or copy the one to a blank spreadsheet
and send it or create a macro to do that. Any other ideas because he didn't
like any of those.

Thanks,
Carla

 

[Norman Jones]

Hi Carla,

See Ron de Bruin's Sendmail page at:

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

 

[Ron de Bruin]

Hi

If you want it easy then use my Add-in
http://www.rondebruin.nl/mail/add-in.htm

 

[Guest]

Heres what I do: While worksheet is open, move cursor over tab at bottom of
worksheet your client wants to email; right click on tab, choose "Move or
Copy"; then select "New book", check in lower left on "create a copy"; click
"OK"; now, go to top, choose FILE and SEND TO: and a copy of the 1 worksheet
will email out.