This post will guide you how to use HyperLink function to send email from Excel. How do I insert a Link to send an email with HyperLink function in Excel 2013/2016. How to create a mailto hyperlink to send a mail from Excel.
Send Email Using Hyperlink Function
Assuming that you have a list of data in range A1:B3, in which contain recipient Email ID, Email subject line, and Email message. And you want to create a mailto link to send an email from Excel. You can use a formula based on the HYPERLINK function and the concatenate operator. Here is one formula that you can use:
=HYPERLINK("mailto:" & B1 & "?subject=" & B2 & "&body=" & B3,"send mail")
Type this formula into a blank cell and press Enter key on your keyboard.
You would notice that one hyperlink has been created and then you can click send mail link from Cell C1. And an Outlook email will be created based on the data in range A1:B3.