| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Email hyperlink | Excel Worksheet Functions | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| email hyperlink | Excel Discussion (Misc queries) | |||
| Email via hyperlink | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
Linear Mode
