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.

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

Thank You!


"Paul B" wrote in message
...
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" wrote in message
...
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.