=hyperlink() for mailto:

[README]

Dear All,

is there a way to use the function =HYPERLINK() with URL longer than 220
characters?

I did tryied a lot but it returns #ERROR and the link does not work anymore
until I reduce string size.

Try it yourself:

A1 (positive integer)
A2 (one or more characters)
B1=REPT(A2,A1)
B2="mailto:name@server?body="&CHAR(34)&B1&CHAR(34)
(CHAR(34) is double quotes)
C1=HYPERLINK(B2;"Click Here")

I'm Excel97 Portuguese, I don't know if the function names is the same as
exemplified above on another languages.

Suggestions wellcome!

TIA & Regards,

readme dot txt zero bytes size

 

[Dave Peterson]

I don't think I've ever tried it with that long of text.

Maybe you could add a little button that does the real work. John Walkenbach
has some code at:
http://j-walk.com/ss/excel/tips/tip86.htm

Maybe you could modify it to do what you want.

Ron de Bruin has tons of tips for email and excel at:
http://www.rondebruin.nl/sendmail.htm

And Dick Kusleika has some Outlook dedicated (IIRC) tips at:
http://dicks-clicks.com/excel/olAutomating.htm

 

[README.TXT]

Hi Dave, It wasn't exactly the case - because I'm not good at VB - but
already helped!
Thanks 4 all

readme