subject in mailto hyperlink formula ignoring characters after & in cell

Copper Contributor

Hello, 

 

I am hoping someone can help with the below formula. I have it working, however when cell F contains an "&" in the text the email subject cuts off from this point and does not pull in the full sentence. SO for instance row 7 Column F pulls in "R9.6 UDMK-953 (D" to the email. Row 6 Column F pulls in the whole sentence.

 

=HYPERLINK(mailto:&Sheet2!$J$2&"""?subject="&$E$1&" "&$A6&" "&$F6&"","Send Email")

 

mattholland1985_0-1675348076426.png

 

1 Reply

@mattholland1985 

How to send email from Excel with mailto hyperlink function?

Added file with example.

=HYPERLINK("mailto:"&sheet2!$J$2&"?Subject="&$E$1&""&$A6&" "&$F6&");""SendEMail")

Please note that it is limited to 255 characters.

 

Additional Mail from Excel exambles

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)