You can't send emails directly form Excel, but there are a few ways to trigger the default mail client on your computer. In this guide, we’re going to show you how to send email in Excel.

Download Workbook

Send email with attachment

If you want to send the file you are working on, the simplest method is Excel's Email command. This command opens a new email including the active file. You can add the command into your Quick Access Toolbar (QAT) by following the steps below.

  1. Click Customize Quick Access Toolbar button at the end of QAT commands.
  2. Click Email to insert the command into your QAT.
    How to send email in Excel 01 QAT
  3. The command will show up in the bar.
  4. Click the Email button to open a new mail. Make sure you have an email client installed, like Outlook.

See Hidden commands in Excel for more commands you can add into your Quick Access Toolbar.

Hyperlink Formula

Excel's HYPERLINK formula is another way to send email from an Excel workbook. You can generate a link that can create a new mail with parameters like subject, cc, bcc or the body.

To trigger the email client, you need to add the "mailto:" prefix the email address you want to send.

=HYPERLINK("mailto:my@email.com")

Although you can't automatically attach an Excel file, like you can with the Email command, you can generate the email content dynamically by cell references.

To add other parameters, add a question mark (?) after the email address(es). Each argument should be separated by an ampersand (&) character.

=HYPERLINK("mailto:clientA@mail.com?cc=sales@mail.com&bcc=vice@mail.com&subject=New Proposal&body=Please review our new proposal in three days")

Here is a cheat sheet:

cc Email address that will receive the mail's carbon copy.
bcc Email that will receive the blind carbon copy of the mail.
; The delimiter for email addresses in the same argument.
subject The subject of the mail.
body The content of the mail.
? The first delimiter after recipient address.
& The delimiter for other parameters.

 

You can omit any argument you want to skip. Here is a sample formula with cell references:

=HYPERLINK("mailto:"&C11&"?cc="&C12&"&bcc="&C13&"&subject="&C14&"&body="&C15)