This tutorial demonstrates how to email an Excel or Google Sheets spreadsheet.
Enable Email Functionality
In Excel, you can email a file (in whole or in part), either as an attachment or as part of the body.
To send a workbook via email, first add the email icon to the Quick Access Toolbar.
- Click on the Customize Quick Access Toolbar icon in the Toolbar, and choose More Commands…
- In the Excel Options window, choose All Commands from the Choose commands from the drop-down list.
- Select Send to Mail Recipient in the list, click Add, and OK.
Now the Email icon is in the Toolbar.
Send Workbook as Attachment
To send an entire workbook in the email attachment, follow these steps:
- Click on the Email icon in the Toolbar.
- In the pop-up window, select Send the entire workbook as an attachment, and click OK.
- As a result, the email is opened in your default email client with your workbook in the attachment. Now, just enter a recipient and email body in order to complete the email.
Send Part of a Worksheet in the Body
You can also send a worksheet (or a range of cells) in the body of an email. Say you want to send only the range B1:F10 of a spreadsheet.
- Select the range of cells you want to send (B1:F10), and click on the Email icon in the Toolbar.
- In the pop-up window, select Send the current sheet as the message body, and click OK.
- When the email window opens, the entire worksheet is inserted into the body. If you want to send only selected cells, click Send this Selection. After that, just add the recipient’s email address and you send the email.
See also: Send Email From Excel – VBA
Send Google Sheet as Email Attachment
In Google Sheets, you can’t send a worksheet or a specific range of cells in an email, but you can send an entire file in the attachment as a PDF, Open Office Spreadsheet, or Excel file.
- From the Menu, go to File > Email > Email this file.
- In the Email window, enter the recipient’s email address, the subject, and the message body. From the drop down, choose a file type and click Send.
This sends your spreadsheet as an attachment, in the format you previously chose.