In this article we will show how to make an email link in google sheets in just a few simple steps using the HYPERLINK function. Simply follow the steps below:
For our example, we have the following sheet containing names and emails.
The emails are stored under the email column header in B1, so the cells containing the emails are B2, B3, etc. We want to insert a link in Column C. We will add a column header called Contact User to cell C1.
To convert the email into a clickable link that lets you send an email to the user, use the HYPERLINK function. It converts a URL stored as a string into a hyperlink. For the emails, use the following syntax:
=HYPERLINK(“mailto:”&email_address, link_label)
Where email_address is the reference to the cell where the email is stored.
link_label is what the label of the link will be.
The formula inserts mailto: at the front of the email address, and then converts it to a clickable URL. Next, it gives the URL a cover label which is what will be visible in Google Sheets as the clickable text.
In our example the formula will add the anchor text “Email Name” to the hyperlink. The name beside the first email value in row 2 is Ann Aribaud so the anchor text for the hyperlink will be “Email Ann Aribaud”
=HYPERLINK(“mailto:”&B2, “Email ”&A2)
The hyperlink will appear in C2.
If you hover your cursor over the link, you will see a pop-up message saying Send to mailto:emailaddress.
Hovering over the message itself will show a contact card containing the email address. If you have saved the email address as a contact, Google Sheets will detect that contact and show the name.
Once you click the link, the default app you set for sending emails on your computer will be loaded with the email in the link set as the recipient.
To convert all the email addresses to links in the column there are two methods you can follow:
Click on the cell and double-click the round blue dot to autofill the column with the formula.
Click on the cell and Click-drag the round blue dot in the lower-right corner of the cell.
Either way, the results will be the same:
We simply need to modify the formula a bit:
=HYPERLINK("mailto:"&email_address, "Email "&LEFT(whole_name,FIND(" ",whole_name)-1))
Where email_address is the cell containing the email and whole_name is the reference to the cell containing the whole name.
This additionally inputs the whole name and outputs Email First Name as the label for the link.
Make sure that the cell containing the whole name does have the whole name with the First Name appearing first. The result can be seen below:
Email link google sheets but displays only first name of recipient
The easiest way to make an email link in google sheets is to simply right click on text in a cell, choose Link from the menu and enter mailto:youremail@domain.com. Once you click enter the link will open your email client and compose a message to the linked email address. It's that simple!
If you enjoyed this article, check out some of our other articles:
Export Email from Google Sheets to Gmail
