Database Mail Not Sending Outside the Company

Question

Database Mail Not Sending Outside the Company

godistop1

SSC Enthusiast

Points: 118
More actions
December 27, 2016 at 9:55 am

#338983

DBMail has been sending out email with attachments inside and outside the company. Added new recipients to existing report which other people are receiving inside and outside the company. New email is outside the company but keep getting the error message:
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2016-12-27T04:48:08). Exception Message: Cannot send mails to mail server. (A recipient must be specified.). "
Able to send test E-Mail and user gets the email. Also, able to send email with attachments to users through Outlook 2110. Because of error above I would think the problem on our side, but cannot find the problem. These reports have been going out with attachments to everyone.
Thanks for any help

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

godistop1 (12/27/2016)
DBMail has been sending out email with attachments inside and outside the company. Added new recipients to existing report which other people are receiving inside and outside the company. New email is outside the company but keep getting the error message:
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2016-12-27T04:48:08). Exception Message: Cannot send mails to mail server. (A recipient must be specified.). "
Able to send test E-Mail and user gets the email. Also, able to send email with attachments to users through Outlook 2110. Because of error above I would think the problem on our side, but cannot find the problem. These reports have been going out with attachments to everyone.
Thanks for any help

By any chance are you getting the recipients from a table? Or getting the list of recipients dynamically somehow?

That's usually when I've seen the error pop up. Usually something with the recipient parameter.

Sue

Lowell SSC Guru Points: 323547 More actions · Answer 2

I'm with Sue;

either an invalid email is being used(ie someone@gmailcom, missing the period) or a null a missing semicolon between multipel addresses, or something for one of your new report receivers, and that is causing the error. note you cannot send to a distribution list name, only to a valid smtp address, which might be mapped to a distribution list.

ie a DL of "Developers" is invalid as a recipient via SMTP, but our mail admin made sure it was additionally mapped to dl.developers@mydomain.com, so we use that in SMTP

the actual email sent is in your failed mail, you can look and see/copy paste the recipients: maybe the cc or bcc fields have a weird value as well.

SELECT top 100

mail.send_request_date As SentDate,

sent_status As Reason,

err.[description],

mail.*

FROM [msdb].[dbo].[sysmail_allitems] mail

inner join [msdb].[dbo].[sysmail_event_log] err

ON err.mailitem_id = mail.mailitem_id

WHERE mail.sent_status <> 'sent'

order by mailitem_id desc

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

godistop1 SSC Enthusiast Points: 118 More actions · Answer 3

THANKS! Both of the responses let me in the right direction. I had copy & paste from Outlook email, apparently there are more than one style of double quotes and DBMail did not like the one from Outlook email. Will see for sure next week when the report runs again. :pinch: