Fully Dynamic Emails from Excel with a SINGLE FORMULA!
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
Видео Fully Dynamic Emails from Excel with a SINGLE FORMULA! канала Leila Gharani
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
Видео Fully Dynamic Emails from Excel with a SINGLE FORMULA! канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution)SUPER EASY Excel Data Entry Form (NO VBA)Excel IF Function with PARTIAL Text Match (IF with Wildcards)10 Super Neat Ways to Clean Data in ExcelSURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)Send Emails from Excel with Power AutomateALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)Learn Macros in 7 Minutes (Microsoft Excel)Easily Import Data from Web to Excel (2 Practical Examples)Searchable Drop Down List in Excel (Very Easy with FILTER Function)Send Full email from Excel with Formula - Without Using Macros by Cool TrickExcel shortcut keys you SHOULD know!Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!Automation: Send bulk emails using VBA and OutlookDatabase vs Spreadsheet - Advantages and DisadvantagesProgress Circle Chart in Excel as NEVER seen before!Excel Hack: Copy Formula Without Changing Cell References (or Without File References)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)