Fully Dynamic EMAILS from excel using Hyperlink
Hope you know that you can create an Outlook email from Excel !!!
You can even create it with an Excel formula using cell references for mailto, subject, cc and body !!! It gives you the ability to create dynamic emails from excel itself.
In this video you will learn how to use the Excel Hyperlink feature to create a manual email hyperlink. We will also learn some key components of the Hyperlink feature that will enable us to make the process dynamic by using Excel's Hyperlink Function.
We have used IF Function to create two different types of emails depending on whether goals were achieved or not. We will also use some of Excel's text functions like TRIM, LEFT and SEARCH function to grab the part of the text we need for our email.
To add a link break in the email body, you can use the carriage return character (%0A).
If you like the video please subscribe my channel !!!