Make a clickable email link
Turn ava@example.com and Ava Reed into a link that says Email Ava Reed.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks if the email cell is empty. | FALSE |
| 2 | "mailto:"&A8 | Where the link goes: a new email to this address. | "mailto:ava@example.com" |
| 3 | "Email "&B8 | The words the link shows. | "Email Ava Reed" |
| 4 | HYPERLINK( … ) | Makes those words a link you can click. | "Email Ava Reed" |
| 5 | IF( … ) | Leaves the cell blank when there is no email. | "Email Ava Reed" |
Parts 2 and 3 go inside part 4. Clicking the link only opens a new email; nothing is sent.
=IF(A8="","",HYPERLINK("mailto:"&A8,"Email "&B8))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own list. Paste emails and labels into the green columns of the Template tab. The links fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use plain addresses only. An address with ? or & in it can open the wrong email.
Microsoft's help: HYPERLINK function
OTHER ROUTES YOU MIGHT LIKE

Mask an email but keep the domain
[email protected] → a***@example.com
Get the template →
Use a secondary email if primary is blank
[email protected] or [email protected] → [email protected]
Get the template →
Build an email address from its two parts
ava + example.com → [email protected]
Get the template →
Check each email went to the right address, once
Your list of 2 → 2 sent copies, each to the right address
Take this route →