Sending Email Using Hyperlink Question

t0ny84

Board Regular
Joined
Jul 6, 2020
Messages
117
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
  3. Web
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,114,276
Messages
5,546,928
Members
410,763
Latest member
TSVIVI
Top