Email hyperlink

[Gavin23]

Hi there
I'm having a small issue with my email hyperlink in that what I have works correctly, only when there is no "&" symbol in the cell that the link is referring to. If there is an "&" symbol in the middle of the string, the hyperlink only extracts the part prior to this.
Is there perhaps a work around ? I can replace the "&" with a "_" (which then works 100%) but this doesn't always apply to the text I'm extracting...

=HYPERLINK("mailto:admin@gmail.com?Subject=Follow%20up: "&CONCATENATE([@[Opportunity Name]]," - Last Comment: ",[@Comments]),"mail")

 

[smozgur]

You need to url encode & character in the URL - replacing it with %26.
Something like this:

=HYPERLINK("mailto:admin@gmail.com?Subject=Follow%20up: "&SUBSTITUTE(CONCATENATE([@[Opportunity Name]]," - Last Comment: ",[@Comments]), "&", "%26"),"mail")

 

[Gavin23]

OMW !!! thanks so much, greatly appreciated !!