Hi William,

2) If you WANTED to do this through VBA, How can one use VBA to reproduce
the effect created in Excel when you choose File - Send To - Mail
Recipient? I can see a single worksheet being worth sending (especially a
chart)

See Ron de Bruin's SendMail page at:

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

---
Regards,
Norman



"William Benson" wrote in message
...
2 questions, pls ...

1) After accidentally clicking Send To Mail Recipients instead of send as
an attachment, how do you get rid of all that Outlook stuff that comes up
(To..., CC..., Subject: etc" to get your worksheet back to normal.

2) If you WANTED to do this through VBA, How can one use VBA to reproduce
the effect created in Excel when you choose File - Send To - Mail
Recipient? I can see a single worksheet being worth sending (especially a
chart)

Thanks