It is correct, it is only when I add my 3rd/4th e-mail address that I get a value error. It appears that hyperlink() are limited to 255 characters.
Insert -> Link does not appear to have the same limitation, but then I am not sure how to add a body to the e-mail.