Fully Dynamic Emails from Excel with a SINGLE FORMULA!
31 October 2019 Excel Advanced Formulas & Features
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
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.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
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.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Timestamps
00:00 How to Create Emails from Excel with a Formula
03:20 How to Use the HYPERLINK Function in Excel
05:29 Add a Subject Line
06:23 Add a CC Recipient
06:57 Add Body Text to the Email
07:22 Add a Line Break to the Body Text
08:27 Wrap Up
What to do if you need:
Excel email with Multiple Mail-to: 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://rumble.com/v2tuwvk
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
RESOURCES I Recommend: https://www.xelplus.com/resources/
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 #Excel #LeilaGharani
-
2:15:48
Laura Loomer
6 hours agoEP52: THE GREAT REPLACEMENT: Trump and Biden Spar Over Border Policies Ahead of First Presidential Debate
45.9K27 -
1:29:23
Kim Iversen
7 hours agoJournalists Critical of Israel Fired and Threatened With Arrest! | What Is “Scholasticide” In Palestine?
65.5K89 -
2:01:58
Melonie Mac
9 hours agoGo Boom Live Ep 6
38K12 -
1:21:32
Game On!
7 hours agoStanley Cup Finals: Oilers vs Panthers Series Preview
32.2K4 -
1:15:28
Precision Rifle Network
1 day agoGuns & Grub S2E7
30.7K5 -
2:23:00
Donald Trump Jr.
13 hours agoLIVE WITH RUSSELL BRAND | TRIGGERED Ep.143
154K212 -
1:19:17
Glenn Greenwald
9 hours agoSteve Bannon's Contempt Charges Reveal Historic Double Standard; Interview with RFK Jr.'s Running Mate Nicole Shanahan on the 2024 Election and More | SYSTEM UPDATE #278
78.5K178 -
1:02:52
The Late Kick with Josh Pate
10 hours agoLate Kick Live Ep 519: CFB’s Biggest ?s | Hall-Of-Fame Broken | Deion Expectations | Bold Predictions
27.3K2 -
59:54
The StoneZONE with Roger Stone
9 hours agoThe 2024 GOP National Platform Will Be Donald Trump's - w/ Ed Martin | The StoneZONE w/ Roger Stone
35.6K1 -
LIVE
Right Side Broadcasting Network
3 days agoLIVE REPLAY: "Chase the Vote" Town Hall With President Donald J. Trump - 6/6/2024
3,049 watching