Click here to Skip to main content
12,698,330 members (23,752 online)
Rate this:
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
Updated 13-Nov-12 17:37pm
Bernhard Hiller 13-Nov-12 8:23am
What about reading the full entry?
Hint: What do those "..." stand for after "The specified string is not"?
ryanb31 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170118.1 | Last Updated 14 Nov 2012
Copyright © CodeProject, 1999-2017
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