Skip to main content

How to send email from Excel with mailto hyperlink function?

In Excel, you can use the mailto hyperlink function to create an email from Excel. The email created by mailto hyperlink includes the recipient’s email address, subject and body. In this article, we will show you how to send email from Excel with mailto hyperlink function.

Send email from Excel with hyperlink function
Send email from Excel with hyperlink function
Easily send email through Outlook based on created mailing list with Kutools for Excel


Send email from Excel with hyperlink function

In this section, I will show you how to directly create a mailto hyperlink in Excel. Please do as follows.

1. Firstly, you need to enter the recipient address, email subject and the email body separately into cell B1, B2 and B3. See screenshot.

2. Select a blank cell which you want the mailto hyperlink locates in, such as cell B4.

3. Copy and paste the hyperlink function =HYPERLINK("mailto:" & B1 & "?subject="& B2 & "&body=" & B3, "Linking text") into the Formula Bar of the selected cell, and then press the Enter key.

Note: In the formula, B1, B2 and B3 contain the recipient’s address, email subject and body; and the “Linking text” is the display text of this hyperlink. You can change them as you need.

From now on, when click the mailto hyperlink, an Outlook email will be created automatically with the specified recipient, subject and body. See screenshot:


Send email from Excel with hyperlink function

As the characters of above method is limited, here I introduce anther method for you to create a mailto hyperlink in Excel.

1. Select a cell which you want to create a mailto hyperlink.

2. Click Insert > Hyperlink. See screenshot:

3. In the Insert Hyperlink dialog box, you need to:

1). Click E-mail Address in the Link to pane;

2). Type the recipient’s email address into the E-mail address box;

3). In the Subject box, type in the email subject, after typing the email subject, enter &body=email body;

For example, if the email subject is “subject of the email” and the email body is “body of the email”, please enter subject of the email&body=body of the email into the Subject box.

4). Click the OK button. See screenshot:

Then the mailto hyperlink is created. Click on it, an Outlook email will be created with all specified recipient’s address, subject and body listed out.


Easily send email through Outlook based on created mailing list with Kutools for Excel

This section will recommend the Send Emails utility of Kutools for Excel. With this utility, you can easily send emails with specified mailing list you have created in Excel. Please do as follows.

Before applying Kutools for Excel, please download and install it firstly.

1. Firstly, you need to create mailing list you need in Excel. Click Kutools Plus > Create Mailing List. See screenshot:

2. In the Create Mailing List dialog box, please check the fields you need to include in the email in both Columns for Mailing list and Attach files sections. Specify a location to place the created mailing list and then click the Create button. See screenshot:

3. Now a sample mailing list is created. Please fill in the corresponding fields with your needed content as below screenshot shown:

4. Select the whole Mailing list, then click Send Emails button in the ribbon. See screenshot:

5. In the Send Emails dialog box, you can see all fields are filled with the corresponding mailing list content, compose the mail body as you need, check the Send emails via Outlook box, and finally click the Send button to send the email. See screenshot:

6. After that, a Kutools for Excel dialog box pops up to tell you about the sending of the email, please click the OK button and close the Send Emails dialog box.

Now you can go to the Outlook's Send Items folder to check the sent email. See screenshot:

  If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Easily send email through Outlook based on created mailing list in Excel with Kutools for Excel


Related article:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (46)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Is there a function to send the whole worksheet as an attachment to the email please?
This comment was minimized by the moderator on the site
Hi Lizzie,

The mailto: protocol does not support adding an attachment. If you want to add the current worksheet as an attachment to the email, you can try one of the methods in this post: How to send worksheet only through Outlook from Excel?
This comment was minimized by the moderator on the site
Hello dear all,

I made the form Hyperlink,=HYPERLINK("mailto:"&J251&"?subject="&'E-mail'!$B$3&" - "&G251&" "&H251&"&body="&'E-mail'!$C$3&", "&G251&" "&H251&". "&'E-mail'!$D$3&"%0A%0A"&'E-mail'!$E$3,"Send E-mail").

As you can se body and subject I am getting from another cel, but it is not allowing me to inform to more than a few characters, any way to solve this?
This comment was minimized by the moderator on the site
How can we edit and put a group email address in the "From" field? For example instead of your default address "", how can we put "" in there?
This comment was minimized by the moderator on the site
Hi Joe,
Do you want to add a contact group to the "From" field or the "To" field? In fact, you can only send emails from one email account. If you want to send an email to a contact group in Excel using the mailto link. You only need to enter the group name into the cell B1 in this case.
This comment was minimized by the moderator on the site
how to add different sending emails (from) address in this formula?
This comment was minimized by the moderator on the site
Hi shehran gill,
In this case, if you want to add different sending addresses, please enter the email addresses in cell B1 and separate them with semicolons.
This comment was minimized by the moderator on the site
Bonjour, est-il possible d'envoyer un lien hypertexte sur une autre messagerie qu'outlook, je voudrais envoyer un tableau à des élèves avec des adresses gmail.
This comment was minimized by the moderator on the site
Hi Isabelle,
You can send emails to any kind of email addresses according to your needs. Outlook just works as your email client.
This comment was minimized by the moderator on the site
Hi Guys,How can I add my default signature to body of email?Thanks for reply
This comment was minimized by the moderator on the site
Hello, I have a question. When I start to blast the email with attachment, there are some mail that have attachments, how to fix it? because I have the test on the different email before and it didn't have a problem
This comment was minimized by the moderator on the site
Is it possible to have a hyperlink of the file path of the workbook itself generated in the body of the email?
This comment was minimized by the moderator on the site
Hi, for the attachment, can it be any type of documents eg word, pdf? how much is your fee if I only want to send mass emails from excel spreadsheet?
This comment was minimized by the moderator on the site
Hello, as per the auto-emailing component, is it possible to have a fixed Subject and a fixed Body? In other words I want to send emails without typing anything.
This comment was minimized by the moderator on the site
I just figured out two work arounds for this trial version user
method 1) is to choose a cell that's outside your data and enter the fixed text there. A1 is the cell I chose for my example. in the formula you just need $ in front of the cell letter and number so it always will go to that cell no matter where you copy the formula to. (shown below in the fixed subject)
method 2) type the fixed info right in your formula with quotes example is the fixed body below

example: =HYPERLINK("mailto:" & B1 & "?subject="& $A$1 & "&body="&"fixed body","AutoEmail")
This comment was minimized by the moderator on the site
Good Day,
This function does not take into account right now yet. Thank you for sharing.
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations