Login to the server - CDO Mail

[sdempsey]

I use the following line of code to send an email:-

exec sp_cdo_sendmail @rec, @sender @subject ,@body

This has stopped working as the recipent has to be authenticated by the mail server before it can send the email out.

Do you know if this is possible to adapt the sp_cdo_sendmail procedure and if so how do you adapt it to authenticate the sender? Which property do you set?

Thanks in advance

 

[sdempsey]

I have established that I am already passing the username and password using the sendusername and sendpassword methods.

However I am getting the following error:-

The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for <email address>

Any ideas

 

[mrdenny]

You need to configure the smtp server to allow relaying to the users domain.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jw2000]

Some receiving email servers do not allow relaying for security reasons. You can disable relaying and send using SMTP server via a static IP connection. Make sure you DNS and RDNS records are set up correctly.