>It appears there is a character limit of 255 characters to at least the @copy_recipients parameter, I'll assume, too, it applies to the @recipients and @blind_copy_recipients as well. I don't see this limit annotated in the xp_sendmail documentation in books on line, is there a work around, other than multiple e-mails?
>
>Thanks
>John
What version of Sql Server are you working with?
Just a WAG, try assign values to the variables first and than pass them to the SP instead of literals.
--sb--