Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server
I had check some mail are properly send but 2 mail are not send.
I had see this error in select * from msdb.dbo.sysmail_log.
The message show:-
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 10 (2012-08-16T03:00:02). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for a subject.). )"
Please some guide me...
Posted 13-Nov-12 1:35am
Edited 13-Nov-12 17:37pm
Bernhard Hiller at 13-Nov-12 8:23am
What about reading the full entry?
Hint: What do those "..." stand for after "The specified string is not"?
ryanb31 at 13-Nov-12 8:28am
You cut off the rest of the error message. What does it say?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Never had I seen such amessage before, and I could hardly believe that such a message is possible. I copied the error message to Google, and voilà, more than a million results...
According to the first hit, some mail programs do not allow the subject to contain line breaks. Just remove them (e.g. replace them with spaces).
By the way, how does it come that you did not do that simple step of asking Google?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 289
1 OriginalGriff 225
2 DamithSL 165
3 Kornfeld Eliyahu Peter 105
4 Peter Leow 105
0 OriginalGriff 7,355
1 DamithSL 5,254
2 Sergey Alexandrovich Kryukov 4,942
3 Maciej Los 4,906
4 Kornfeld Eliyahu Peter 4,514

Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 14 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100