Excel formula with hyperlink to get e-mail with a signature

Jonathan Brotto 1,076

I am testing the hyperlink formula in excel to send e-mails but was wondering if there is a way to include the body of custom text I have along with the default signature for any outgoing e-mail I have in outlook?

=HYPERLINK("mailto:jonathan@ultident.com"&"?subject=subject test "& " " & "&cc=jonathan@ultident.com" & "&bcc=jonathan@ultident.com" & "&body=body test with a %0A new line","test e-mail")

Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor

2022-01-17T03:49:11.707+00:00

Hi @Jonathan Brotto ,
Hyperlink function can only help you create the hyperlink for email address but cannot create any custom body text.
In my opinion you should create VBA code in Excel or Outlook and help you get the result.
Jonathan Brotto 1,076 Reputation points

2022-01-17T14:25:05.153+00:00

I turned on the developer tab in outlook but there is no record button.

Also when I record in excel it does not record any of the outlook items.
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor

2022-01-18T08:18:46.88+00:00

Hi,
I suggest you post the issue to the new tag office-vba-dev, this is a way for users ask question about VBA code in Office. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.