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