Sending an email directly from an Excel spreadsheet eliminates the repetitive task of switching between windows and manually copying data. Whether you need to send a quick copy of a budget or automate a monthly payroll notification to hundreds of employees, Excel provides multiple built-in and programmable methods to get the job done.

The following sections cover various techniques ranging from simple built-in sharing features to advanced automation using VBA and Power Automate.

Quick Methods for Sending Workbooks and Sheets

For users who do not require automation and simply want to share their data, Microsoft Excel provides several native options. These methods are most effective for one-off communications where personalization is not a priority.

Sharing the Entire Workbook as an Attachment

The most straightforward way to email your Excel data is by using the integrated Share feature. This method triggers your default email client—usually Microsoft Outlook—and creates a new message with the workbook already attached.

  1. Open the Excel file you wish to send.
  2. Click on the File tab in the top-left corner.
  3. Select Share from the left-hand sidebar.
  4. Choose Email (or Send a copy in newer versions of Microsoft 365).
  5. Select Send as Attachment.
  6. A new Outlook message window will appear. Enter the recipient’s address, add a subject line, and click Send.

Exporting and Emailing as a PDF

In many professional scenarios, you may want to send your spreadsheet in a non-editable format to ensure data integrity.

  1. Navigate to File > Share > Email.
  2. Select Send as PDF.
  3. Excel will automatically convert the active sheets into a PDF document and attach it to a new email.

Sending a Single Worksheet

If your workbook contains dozens of tabs but you only need to share one, sending the entire file is inefficient.

  1. Right-click the tab of the worksheet you want to send at the bottom of the screen.
  2. Select Move or Copy.
  3. In the To book dropdown menu, select (new book).
  4. Check the box for Create a copy and click OK.
  5. This opens the single sheet in a new, temporary Excel window.
  6. Use the File > Share > Email method described above to send this specific sheet.

How to use the Excel HYPERLINK function for email?

The HYPERLINK function is a powerful, low-code tool that allows you to create clickable "Send Email" links directly within your cells. This is ideal for CRM-style spreadsheets where you want to click a link next to a client's name to launch a pre-filled email.

The Basic Mailto Syntax

The function uses the mailto: protocol. The basic syntax is: =HYPERLINK("mailto:recipient@example.com", "Click to Email")

Adding Subject Lines and Body Text

To make these links truly useful, you can concatenate cell values to populate the subject line, CC field, and the body of the email.

The formula structure: =HYPERLINK("mailto:" & A2 & "?subject=" & B2 & "&body=" & C2, "Send Update")

  • A2: Contains the recipient's email address.
  • B2: Contains the subject line text.
  • C2: Contains the body content.

Dealing with Character Limits and Formatting

In our practical tests with large datasets, the HYPERLINK method has a significant limitation: the total length of the URL cannot exceed 255 characters in some versions of Excel. If your email body is long, the link will fail to work.

Additionally, to create line breaks in the body of the email, you must use the URL-encoded character for a new line: %0D%0A.

Example of a multiline body formula: =HYPERLINK("mailto:sales@company.com?subject=Order&body=Line1%0D%0ALine2", "Contact Sales")

Automating Mass Emails with Word Mail Merge

When you need to send personalized emails to a large list—such as sending unique invoices to 200 different vendors—the mailto: function is too manual. This is where the integration between Excel and Microsoft Word becomes essential.

Preparing the Excel Data Source

For a Mail Merge to work correctly, your Excel data must be "clean."

  • Headers: Ensure the first row contains clear headers (e.g., First_Name, Email_Address, Amount_Due).
  • No Blank Rows: Remove any empty rows within your dataset.
  • Data Types: Ensure the email column is formatted as "General" or "Text" to prevent Word from misinterpreting symbols.

Executing the Mail Merge in Word

  1. Open a blank Microsoft Word document.
  2. Go to the Mailings tab and click Select Recipients > Use an Existing List.
  3. Locate and select your Excel workbook.
  4. Choose the specific sheet where your data resides.
  5. In Word, write your email template. Where you want to insert personalized data, click Insert Merge Field and select the corresponding Excel header.
  6. Once the template is ready, click Finish & Merge > Send Email Messages.
  7. In the popup, select the column that contains the email addresses and specify the subject line.

This method is highly reliable for bulk sending because it processes the list sequentially through your Outlook account.

Using VBA to Send Customized Emails from Excel

For users who require deep customization—such as attaching specific files based on a cell value or sending emails only when certain conditions are met—Visual Basic for Applications (VBA) is the standard solution.

Enabling the Developer Tab

Before writing VBA code, you must enable the Developer tab in Excel:

  1. Right-click any tab on the Ribbon and select Customize the Ribbon.
  2. Check the box for Developer in the right-hand column and click OK.

Writing a Basic Email Script

The following script iterates through a list of emails and sends a message using the Outlook Object Model. To use this, you must go to Tools > References in the VBA editor and check Microsoft Outlook 16.0 Object Library.