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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,114,072
Messages
5,545,822
Members
410,707
Latest member
SanTrapGamer
Top