Sending Email Using Hyperlink Question

[t0ny84]

Hi Everyone,

I have came across a function of sending an email using they Hyperlink Function of Excel, the idea behind it is using the following formula as a hyperlink generates an email in Outlook. I am trying to figure out a way to get this feature to work but include a table within the body of the text. e.g. the Body would be:

Hi,

Please find your next month's schedule:

TABLE HERE

Regards,
John Smith

Formula =HYPERLINK("mailto:" & "EMAIL TO SEND TO" & "?subject="& "SUBJECT TEST" & "&body=" & "BODY TEXT", "Excel Hyperlink Text")

More Information Here - Email From Excel Guide

Thanks in advance!
t0ny84