How to Send A Workbook/Worksheet Within Excel Using Outlook

If you want to share only a specific Excel worksheet via email, you can do this directly from Excel using the 'Send to Mail Recipient' feature. This will require Microsoft Outlook to be set up on your computer. Here's how:

Step 1: Select the Worksheet

Open the workbook and select the worksheet you want to send.

Step 2: Copy the Worksheet to a New Workbook

Go to the Home tab > Format > Move or Copy Sheet.

In the pop-up window, select (new book) under To book and check Create a copy, then click OK. This will open a new workbook with only the selected worksheet.

Step 3: Send the Worksheet via Outlook

In the new workbook, go to the File tab > Share > Email > Send as Attachment. This will open a new email in Outlook with the new workbook as an attachment.

Step 4: Compose Your Email

In the new email window, enter your recipient's email address, a subject, and a message. When you're done, click Send.

Remember to save the new workbook if you need to keep it for future use.