Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-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.

⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/send-email-excel-file

In this tutorial, we explore the power of Excel's hyperlink formula to create dynamic emails directly from your spreadsheet. Perfect for users who frequently send out emails with varying content, this video guides you through the process of setting up automated emails that include customizable subject lines and body text, all driven by cell references in Excel.

What You'll Learn:
▪️ Automating Emails with Excel: Discover how to use Excel formulas to send emails without opening Outlook.
▪️ Dynamic Email Content: Learn to create emails with varying subjects and body texts based on specific cell values.
▪️ Using Excel's HYPERLINK Function: Master the use of the HYPERLINK function to craft emails, add CC recipients, and even include line breaks in the body text.

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.

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.

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

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

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!

#excel