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