Dear All,
In my application, mails are being sent through SQL Server in the following manner,
EXEC MSDB.DBO.SP_SEND_DBMAIL
@PROFILE_NAME = 'Mail Alerts',
@RECIPIENTS ='AnyEMailID',
@BLIND_COPY_RECIPIENTS='MultipleEMailIdsSeparatedBy;',
@file_attachments='D:\Birthday Reminders\FINAL2.jpg',
@BODY ='<html><body>Testing</body></html>',
@BODY_FORMAT ='HTML',
@SUBJECT = 'BCC Text Size Test'
The above works well when size of charatcters in @BLIND_COPY_RECIPIENTS is around 8000 characters.
But when the size goes beyond 8000 characters, the mail does not shoot.
The sysmail_mailitems table shows status as 2 for the same.
Checking the sysmail_log table shows following exception:
The mail could not be sent to the recipients because of the mail server failure.
(Sending Mail using Account 1 (2013-04-26T17:29:34).
Exception Message: Cannot send mails to mail server. (Failure sending mail.). )
I fail to understand the issue as the size of @BLIND_COPY_RECIPIENTS is varchar(max).
I have searched a lot on the internet but could not find anything related to this issue.
Please help as I need to close this issue.
Thanks,
Gopal
Some One Please reply....