We are trying to send a simple message using database mail to a
hotmail account and hotmail never seems to get it. The code looks
like:

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'My_Mail',
@recipients = 'someemail@hotmail.com',
@body_format = 'text',
@body = 'this is a test',
@subject = 'Hotmail test' ;

The profile is configured correctly as far as we can tell since we
receive messages sent to yahoo.com or other domains. Just never gets
to hotmail.

Any ideas?

Thanks in advance.

What are the spam / junk mail filter settings for the account? Did you try
multiple hotmail accounts with different settings? Is the reply-to address
valid so that if the mail is being bounced you will see it somewhere?

(This isn't really a configuration issue on the side of SQL Server.)

A


On 5/21/08 11:03 PM, in article
18185920-2ebf-4883-b1f3-020825eebf01...oglegroups.com, "Chris"
<halldatainc@gmail.com> wrote:

> We are trying to send a simple message using database mail to a
> hotmail account and hotmail never seems to get it. The code looks
> like:
>
> EXEC msdb.dbo.sp_send_dbmail
> @profile_name = 'My_Mail',
> @recipients = 'someemail@hotmail.com',
> @body_format = 'text',
> @body = 'this is a test',
> @subject = 'Hotmail test' ;
>
> The profile is configured correctly as far as we can tell since we
> receive messages sent to yahoo.com or other domains. Just never gets
> to hotmail.
>
> Any ideas?
>
> Thanks in advance.

Thanks for the reply! Hotmail filter settings are as follows:
Filter Level:
Standard - Most junk e-mail is sent to the junk e-mail folder.
When junk mail is deleted:
Later - Junk e-mail is automatically moved into the junk e-mail
folder, where it is deleted after ten days.
Junk reporting:
Don't report - The Junk button will act just like the Delete
button. Nothing will be reported to Microsoft or anyone else.

These are the default settings as far as I can tell. I tried changing
the filter level to low but still couldn't get any emails through. I
tried sending to some hotmail accounts of colleagues - most likely on
default settings as well but I can't say for sure. The reply address
is valid as well.

I know this isn't a true SQL configuration issue but I was hoping
someone else mgiht have encountered the same problem and could make a
suggestion.