Sending Mail

[grimmy26]

I am trying to send mail from my SQL server and do not want to load outlook on it to get the MAPI so I have found the following document which does exactly what I want.

http://www.sql-server-performance.com/dh_sending_sql_notifications_cdosys.asp

The only problem is that it is not working even though the job is ending successfully but in the job history the error is saying "The SMTP server name is required and was not found in the configuration source"

Now I have put the IP address of our SMTP server in where it states so do not understand why this will not work.

Any ideas??

 

[NathanGriffiths]

Did you put the SMTP server name or address in both the IIS SMTP Services setup and the stored procedure code?

 

[timfurry]

I've been playing with this myself, and noticed that when I cut and paste the code from the page you mentioned, there's an extra blank in the line that specifies the SMTP server. Remove the blank and it works fine.

'Configuration.fields("

http://schemas.X<--

blank is here microsoft.com/cdo/configuration/smtpserver").Value'

 

[mrdenny]

You can also use xp_smtp_sendmail to send emails via smtp without using the sp_OA procs.

Denny

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

 

[timfurry]

I'll look into that...thanks for the tip.

 

[mrdenny]

no problem. You can google for it, should be the third or fourth link on the page.

Denny

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

 

[grimmy26]

changed the code slightly and all working fine now. Cheers for the help and if anybody wants the code than just ask