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