How to Send Emails from Excel with Single Formula | NO VBA Required

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.

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.

Formula for:
Subject: =IF(E2="","","Thank you "&TRIM(LEFT(A2,SEARCH(" ",A2))))

Checkout the latest deals: amzn.to/3pVH21e


Body: =IF(E2="","","You achieved your goal of "&D2&".%0AYou even exceeded your goal by "& E2&"!")

Send Email: =IF(E2="",HYPERLINK("mailto:" & B2 & "?subject=Let's do this&body=Try harder next month!", "Send Motivation"),HYPERLINK("mailto:" & B2 & "?subject="& F2 & "&body=" & G2, "Send Email"))