Email hyperlink

Gavin23

New Member
Joined
Jul 10, 2014
Messages
13
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")
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
932
You need to url encode & character in the URL - replacing it with %26.
Something like this:

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

Watch MrExcel Video

Forum statistics

Threads
1,095,672
Messages
5,445,896
Members
405,368
Latest member
mistersend

This Week's Hot Topics

Top