Post reply

sp_send_dbmail returns with no errors when @copy_recipients is not supplied, but does not send message

  • April 15, 2011 at 2:47 pm

    #389299

    Can anybody tell me why I can get this to work:

    exec msdb.dbo.sp_send_dbmail @copy_recipients = 'ryanbesko@hotmail.com', @body = 'Test Body'

    ... but I can't get this to:

    exec msdb.dbo.sp_send_dbmail @recipients = 'ryanbesko@hotmail.com', @body = 'Test Body'

    It returns the message "Mail queued" for both, but I only get an email for the first statement.

  • April 15, 2011 at 4:30 pm

    #1312390

    could it be a relaying/mail forwarding problem? are you supplying a username and password for the AUTH command for your mail server?

    is the first destination email going to an address on the same domain as the mail server?

    i'm thinking that is the issue; with no username/password, the mail server will not anonymously forward to the hotmail domain, and only accept inbound emails for the domains it administers.

    my mail profile when using the gmail servers requires the AUTH, so my gmail account looks like this for example; note the "basic authentication" section? that's where i bet yours is blank.

    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!

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

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