Forum Discussion
subject in mailto hyperlink formula ignoring characters after & in cell
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...
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.
I know I don't know anything (Socrates)