You can but it needs to be sent as a body of the email.

1. Open the Excel workbook you want to extract the worksheet from.
2. Be on the worksheet you want to email, and click File,  Send To, Mail
    Recipient.  A window box will appear asking whether you want to send
    the whole workbook or the current sheet as the message body.

The second option will insert the active sheet into the body of the email message. The first option will email the complete workbook.