Fully Dynamic Emails from Excel with a SINGLE FORMULA!

Share this & earn $10
Leila Gharani
Published at : 20 Dec 2020
517560 views
14964
171

Did you know you can create an Outlook email from Excel? You can even create it with an Excel formula using cell references for mailto, subject and cc? The Excel Hyperlink formula gives you the ability to create dynamic emails.

In this video you will learn how to use the Excel Hyperlink feature to create a manual email hyperlink. As we're doing this step, we learn some key components of the Hyperlink feature that will enable us to make the process dynamic by using Excel's Hyperlink Function.

This Excel tutorial will also show you how you can get creative with the Hyperlink function. We will use the Excel IF Function to create two different types of emails depending on whether goals were reached or not. We will also use some of Excel's text functions like TRIM and LEFT function to grab the part of the text we need for our email.

What to do if you need:
Excel email with Multiple Mailto: If you'd like to have multiple recipients for the mailto address, just add the email addresses in the same cell and separate them with a semicolon.

Add a Line break to email body: To add a link break in the email body, you can us the carriage return character (%0A).

Beware of Excel's formula 255 character limit - you can't use the Hyperlink formula for extra long emails. Keep the [friendly name] as short as you can to allow for more characters in the rest of the email.

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/send-email-from-excel-with-hyperlink-formula

Excel IF Function Tutorial: https://youtu.be/KkTaQ5OjAGc

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel
XelplusVisLeila GharaniAdvanced Excel tricks

Colby O'Donis ft. Akon - What You Got (Official Video)

Colby O'Donis ft. Akon - What You Got (Official Video)

Eduarda Henklein - System Of A Down (cover)  Multishow

Eduarda Henklein - System Of A Down (cover) Multishow

Answering your Japanese questions / またツイッターで日本語の質疑応答を行なってみた

Answering your Japanese questions / またツイッターで日本語の質疑応答を行なってみた

PROCUREMENT MANAGER Interview Questions And Answers (Procurement Officer Job Interview Tips!)

PROCUREMENT MANAGER Interview Questions And Answers (Procurement Officer Job Interview Tips!)

Laser cutting of a printed MDF event bus - Laserschneiden eines Event-Buses aus MDF - eurolaser

Laser cutting of a printed MDF event bus - Laserschneiden eines Event-Buses aus MDF - eurolaser

HOW MEN TEST YOU TO SEE HOW THEY'RE GOING TO TREAT YOU: (TEACHING YALL THE GAME)

HOW MEN TEST YOU TO SEE HOW THEY'RE GOING TO TREAT YOU: (TEACHING YALL THE GAME)

The Rise and Fall of Driver

The Rise and Fall of Driver

INSTANT POT Vegan Yogurt! How to Make EASY, Healthy and Inexpensive Vegan Yogurt!

INSTANT POT Vegan Yogurt! How to Make EASY, Healthy and Inexpensive Vegan Yogurt!

Simple Language Techniques | English

Simple Language Techniques | English

The Simple TRUTH: Why You're Not Attracted To More Men (Matthew Hussey, Get The Guy)

The Simple TRUTH: Why You're Not Attracted To More Men (Matthew Hussey, Get The Guy)

6 Habits That Destroy Your Emotional Wellbeing

6 Habits That Destroy Your Emotional Wellbeing

#PubgMobile #montage specially #7k Subs 🔥 Scode Wipe 1v4 Top Best Clutchs 🔥🔥

#PubgMobile #montage specially #7k Subs 🔥 Scode Wipe 1v4 Top Best Clutchs 🔥🔥

Painter/Sculptor Peter Reginato talks about reworking a painting

Painter/Sculptor Peter Reginato talks about reworking a painting

Crushing Crunchy & Soft Things by Car! - A lot of Antistress toys vs Car

Crushing Crunchy & Soft Things by Car! - A lot of Antistress toys vs Car

Algebra Basics: Simplifying Polynomials - Math Antics

Algebra Basics: Simplifying Polynomials - Math Antics

Michael Jackson - The Lady in My Life (Audio)

Michael Jackson - The Lady in My Life (Audio)

Time and Effort Will Make You a Better Person | Joe Rogan and CT Fletcher

Time and Effort Will Make You a Better Person | Joe Rogan and CT Fletcher

Bobby "Blue" Bland - Get Your Money Where You Spend Your Time

Bobby "Blue" Bland - Get Your Money Where You Spend Your Time

Russian Countryside August 2018

Russian Countryside August 2018

Girl MyFlex #sexy #hot #bikini #lingerie #tryon striptease from a flexible #underwear #swimwear #bra

Girl MyFlex #sexy #hot #bikini #lingerie #tryon striptease from a flexible #underwear #swimwear #bra

Nightcore - O.D.D. (Lyrics)

Nightcore - O.D.D. (Lyrics)

How to unlock Companion in PUBG Mobile ? How To Get Companion in PUBG Mobile ?

How to unlock Companion in PUBG Mobile ? How To Get Companion in PUBG Mobile ?

Bibliomania- A Film of the Thirty-Sixth ABAA California Bookfair

Bibliomania- A Film of the Thirty-Sixth ABAA California Bookfair

Dana  - The Far Off Place

Dana - The Far Off Place

Evelyn Higginbotham  - JUST LIKE EVERY MORNING (1990)

Evelyn Higginbotham - JUST LIKE EVERY MORNING (1990)

Rappers We Lost in 2018

Rappers We Lost in 2018

I Will Come and Bow Down (Live) - Ron Kenoly

I Will Come and Bow Down (Live) - Ron Kenoly

Bungie ViDoc - Forged in the Storm

Bungie ViDoc - Forged in the Storm

Fortnite Item Shop *NEW* BIGGEST SHOP EVER!? [October 29th, 2020] (Fortnite Battle Royale)

Fortnite Item Shop *NEW* BIGGEST SHOP EVER!? [October 29th, 2020] (Fortnite Battle Royale)

Reward for info on ice cream vendor's killing now up to $24,000, thanks to community groups

Reward for info on ice cream vendor's killing now up to $24,000, thanks to community groups

Обзор на САМЫЕ УМНЫЕ ЧАСЫ для БЛОГЕРОВ **СЧИТАЮТ ПОДПИСЧИКОВ**

Обзор на САМЫЕ УМНЫЕ ЧАСЫ для БЛОГЕРОВ **СЧИТАЮТ ПОДПИСЧИКОВ**

Khabardar: Indian Army All Prepared At Border After Surgical Strike

Khabardar: Indian Army All Prepared At Border After Surgical Strike

МНЕНИЕ ВИТАЛ ШАРКА о ШЕРЕМЕТЕ | Нарезка со стрима Vital Shark

МНЕНИЕ ВИТАЛ ШАРКА о ШЕРЕМЕТЕ | Нарезка со стрима Vital Shark

What's Your Favorite Color? | Kids Songs | Super Simple Songs

What's Your Favorite Color? | Kids Songs | Super Simple Songs

Two Surgeries In One Week.....| StassieBaby

Two Surgeries In One Week.....| StassieBaby

Bom dia 247: Lula, aos 75, busca Justiça

Bom dia 247: Lula, aos 75, busca Justiça

The Gods Must Be Crazy 1980

The Gods Must Be Crazy 1980

Behavioural Economics - Availability Bias

Behavioural Economics - Availability Bias

How To Buy a House Without a Realtor | FOR SALE BY OWNER TIPS

How To Buy a House Without a Realtor | FOR SALE BY OWNER TIPS

Writing Lesson Objectives for Classroom Teachers

Writing Lesson Objectives for Classroom Teachers

Битвы взглядов UFC 254: Хабиб - Гэтжи / Final face offs Khabib vs Gaethje weight in staredowns

Битвы взглядов UFC 254: Хабиб - Гэтжи / Final face offs Khabib vs Gaethje weight in staredowns

How To Make Sure Your Song Is Ready For Streaming

How To Make Sure Your Song Is Ready For Streaming

How to Install Sheet Vinyl Around a Toilet

How to Install Sheet Vinyl Around a Toilet

Today, you need to make a choice that may lead to prosperity or struggles for life!

Today, you need to make a choice that may lead to prosperity or struggles for life!

01049 Spanish Lesson - Personal A

01049 Spanish Lesson - Personal A

Madness - House of Fun (Official Video)

Madness - House of Fun (Official Video)

Luckily founding and catching many beautiful and lovely KOI Japan, Ranchu and Oranda

Luckily founding and catching many beautiful and lovely KOI Japan, Ranchu and Oranda

loaf around

loaf around

Mozart Classical Music: Concentrate with this Relaxing Piano Music while Studying or Reading

Mozart Classical Music: Concentrate with this Relaxing Piano Music while Studying or Reading