>>>>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.

appreciate the effort Borislav - thanks.
that is the message that came up with my overloaded cell and i really don't have a clue how to get that concatenate function to work never had occasion to use it. K