How to email 1 sheet in a workbook?

[Hosh]

I have a workbook with an individual sheet for every month in the year. At
the end of each month, that month's sheet must be emailed corporate wide.
Presently, I copy that month's sheet to a new workbook and send that
workbook out as an email.

Isn't there a way that I can just send one sheet out without creating a new
workbook that only has 1 month in it?

Thanks.

 

[Paul B]

Hosh, have a look here at Ron's site for a way to do it,
http://www.rondebruin.nl/mail/folder1/mail2.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Hosh]

Thank You!

Hosh, have a look here at Ron's site for a way to do it,
http://www.rondebruin.nl/mail/folder1/mail2.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003