Email all pages of a current worksheet

[patd@cadorath.com]

Hi everyone.

Here is one that I am troubled with.
I have a workbook that has worksheets by the month
I enter data into a main sheet with data going into the corrent month that I am working on.
Is there a way to email just the current month to a group of people?

regards

Pat

[shg]

Please change either your title or your post so they agree -- is the question about printing or emailing?

[teylyn]

... and maybe post in a question forum instead of this one!

[shg]

Thanks, teylin, didn't notice, I will move the thread.

To do it manually, copy the sheet to a new workbook (right-click sheet tab, select Move or Copy sheet, ...), and then File > Send to.

To do it via VBA, see http://www.rondebruin.nl/sendmail.htm