How to email 1 sheet in a workbook?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hosh - 05 Apr 2007 11:35 GMT

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.

Reply to this Message

Paul B - 05 Apr 2007 11:48 GMT

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

Signature

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

> 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.
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Hosh - 05 Apr 2007 13:42 GMT

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
[quoted text clipped - 10 lines]
>>
>> Thanks.

Reply to this Message