E-mailing a single sheet from a workbook

There are two ways in which this can be done.

1. If you click on the "Send to mail recipient" button, you can select the option Send the current sheet as the message body. This will allow you to send the information in the sheet as part of the body of the message (not as an attachment). (Note: You can add the "Send to mail recipient" button to your quick access toolbar by clicking on the arrow on the toolbar and selecting More commands -> Select Choose commands from: Commands Not in the Ribbon -> Find Send to Mail Recipient and click on Add>>)
2. If you need to send the sheet as an attachment then make a copy of the sheet and add it to a new workbook: Right click on the sheet tab, select Move or copy, select new book from the drop-down list, and select Create a copy. Then send the newly created workbook with just the one sheet.