I am having a problem with my SQL Server 2005 database email not sending emails to a user with a hyphen in the domain of their email address. (i.e. email@example.com).
According to the msdb.sysmail_mailitems table the email is being sent without error and everyone else who is on the recipients list is receiving the email just not the individual with the hyphen in the domain name of the email address.
The user explained that the email is not in their spam/junk folder.
Can you successfully send an email to them through the email server you are using for DB Mail? Have you verified that the email address is entered correctly?
All the "Sent" status means is that the SMTP server accepted the email from database mail, it doesn't mean you have a valid email address or that it left the SMTP server.
answered Mar 16 '10 at 10:04 AM
One thing that I think about is how the hyphen can cause problems in objects. I know that for me I would normally have to put brackets around an object with a dash in it.
Object-1 would have to be [Object-1]
answered Mar 10 '10 at 11:09 AM
I would get the recipient to check with their IT guys. Some mail servers are quite picky about which emails they deliver to the target mail account. Try sending a test email to them from SQL and get them to have their IT guys look for it in their mail server to see what happens to it. You might need to tweak the mail profile you've set up for SQL.
answered Feb 23 '10 at 05:00 AM