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

Hi Carla,

See Ron de Bruin's Sendmail page at:

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

---
Regards,
Norman



"Carla Bradley" wrote in message
...
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

Hi

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


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


"Carla Bradley" wrote in message ...
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

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.

"Carla Bradley" wrote:

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