EMail Hyperlink TO limited to 10 char
 

I have created a hyperlink to create an EMail from Excel when you press the
cell

=HYPERLINK("mailto:"&D7&"?subject="&D6&" has completed the recon for
"&D2&"&body="&D2&" is waiting for your approval. %0d%0a %0d%0aThanks,
"&D6&"%0d%0a%0d%0a%0d%0a")

but if the name for the "mailto:" in D7 is greater than 10 char, it will
take you to Notes but not create an EMail? Any clue why and if there is a
way to increase this? Most names are over 10char

thanks

EMail Hyperlink TO limited to 10 char
 

Could it be that I need to use Concatenate within the Hyperlink? It does not
always fail , which is weard

"Don" wrote:

I have created a hyperlink to create an EMail from Excel when you press the
cell

=HYPERLINK("mailto:"&D7&"?subject="&D6&" has completed the recon for
"&D2&"&body="&D2&" is waiting for your approval. %0d%0a %0d%0aThanks,
"&D6&"%0d%0a%0d%0a%0d%0a")

but if the name for the "mailto:" in D7 is greater than 10 char, it will
take you to Notes but not create an EMail? Any clue why and if there is a
way to increase this? Most names are over 10char

thanks

EMail Hyperlink TO limited to 10 char = Length too long
 

"Don" wrote:

I have created a hyperlink to create an EMail from Excel when you press the
cell

=HYPERLINK("mailto:"&D7&"?subject="&D6&" has completed the recon for
"&D2&"&body="&D2&" is waiting for your approval. %0d%0a %0d%0aThanks,
"&D6&"%0d%0a%0d%0a%0d%0a")

but if the name for the "mailto:" in D7 is greater than 10 char, it will
take you to Notes but not create an EMail? Any clue why and if there is a
way to increase this? Most names are over 10char

thanks

EMail Hyperlink TO limited to 10 char
 

looks like there is a limit to the number of charactors including the names
from other cells. I have shortened the statments and now the name works

"Don" wrote:

I have created a hyperlink to create an EMail from Excel when you press the
cell

=HYPERLINK("mailto:"&D7&"?subject="&D6&" has completed the recon for
"&D2&"&body="&D2&" is waiting for your approval. %0d%0a %0d%0aThanks,
"&D6&"%0d%0a%0d%0a%0d%0a")

but if the name for the "mailto:" in D7 is greater than 10 char, it will
take you to Notes but not create an EMail? Any clue why and if there is a
way to increase this? Most names are over 10char

thanks