>>>I am generating excel files in vfp that will have one cell defined as a hyperlink - the hyperlink will contain a string of email addresses but is limited to 255 characters i believe.
>>>
>>>The following entry creates the email properly. In fact i will have a lot more email recipients i need to include. Any way around this limitation?
>>>
>>>credit to Chris Hagerman
>>>

>>>=(HYPERLINK("Mailto:email@myplace.ca?subject=my information&bcc=hiddenemail@email;email2@email;email3@email;email4@email;email5@email&body=can i get this to work in excel"))
>>>

>>>
>>>many thanks for any suggestions
>>>k
>>
>>Try to use "friendly name"
>>

>>=(HYPERLINK("Mailto:email@myplace.ca?subject=my information&bcc=hiddenemail@email;email2@email;email3@email;email4@email;
>>            email5@email&body=can i get this to work in excel";"This is eMail Hyperlink"))
>>

>>(Tested only on Excel 2007 :-))
>
>thanks Borislav
>problem is these files will be distributed to people who do not have the friendly email name lists in their address book - besides - that would still only buy me 255 character limit no?
>
>k

It didn't work in 2007 also.
Just your string is smaller than 255 chars :-)
I couldn't get it to work, even tried the suggestion from Excel that if the string exceed 255 limit I must use CONCATENATE function.