MrExcel Publishing
Your One Stop for Excel Tips & Solutions

EMAIL SHEET FROM EXCEL


Posted by MIKE K on June 12, 2001 7:54 AM

IS THERE A WAY TO EMAIL JUST A SPECIFIC SHEET FROM EXCEL. NOT THE WHOLE BOOK?
THANKS!


Posted by lenze on June 12, 2001 9:14 AM

There are a couple of ways. If you are using Excel 2000, you can choose File>Send To>Mail Recipient. You will have the option to send the entire Workbook as an attachment, or the current sheet as the body of an email.

If you need to send the only one sheet, but as a workbook, right click on the sheet tab and choose move or copy. Select the copy option and choose New Workbook. Only this sheet will be copied to a new workbook, which you can then email