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.
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.
- Click Customize Quick Access Toolbar button at the end of QAT commands.
- Click Email to insert the command into your QAT.
- The command will show up in the bar.
- Click the Email button to open a new mail. Make sure you have an email client installed, like Outlook.
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.
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.
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: