MrExcel Publishing
Your One Stop for Excel Tips & Solutions

e-mailing worksheets

Posted by Mary McKechnie on December 04, 2001 2:37 PM

Hi out there:

This may be too silly to post, but I can't seem to figure out how to e-mail just a single sheet from a workbook without copying it to a new book. The file I'm working with requires 1 sheet to be sent to finance and other sheets to different supervisors. (There are 29 sheets total so I hate to send the whole thing.

Thanks for any help


Posted by Juan Pablo G. on December 04, 2001 3:23 PM

I know it's not exactly what you want, but you can do that by copying the active (Or any) sheet to a new workbook, mail it, and close it without saving changes. All with ScreenUpdating turned off may seem that you haven't added a new book.

I know Microsoft added that option in XL2000, but noone i know has been able to find how to control the "Just active sheet" part of the SendMail method...

Juan Pablo G.