Forum Discussion
Help with Hyperlink formula
Hi all,
So basically I am trying to do a hyperlink formula but everyone I get to the "&body=" part, what ever I try does not seem to work. I have tried linking it to a cell with the information I want added from body into the email and I have tried directly putting the information after the '=' but I keep getting an error message and I can't figure out where I have gone wrong?
The formula went something like this...
=HYPERLINK("mailto:" & B1 & "? subject="& B2 & "&body=" & B3, "send email ")
"&B3" basically linking to a cell that says' Thank you for your support'.
1 Reply
One possible issue with your formula could be that the body text contains spaces or special characters that need to be URL encoded.
You can try replacing spaces with %20 and other special characters with their URL encoded equivalents.
For example, if the text in cell B3 is “Thank you for your support”, you can try replacing it with “Thank%20you%20for%20your%20support” in the formula.
So the formula would look like this:
=HYPERLINK("mailto:" & B1 & "?subject=" & B2 & "&body=Thank%20you%20for%20your%20support", "send email")
I hope this helps!
