Hi,

I want send a formated mail ,every one hour to our client's I want to
use SQL Server ,is their any way do it.



*** Sent via Developersdex http://www.developersdex.com ***

You got to use an schaduled job by using this Extended store proc:
http://www.sqldev.net/xp/xpsmtp.htm

HTH
Ray

"Himanshu Kaushal" <ogs_himanshu (AT) yahoo (DOT) com> wrote

Sorry I meant:
You got to use an schaduled job **AND** using this Extended store proc:
http://www.sqldev.net/xp/xpsmtp.htm


"Ray5531" <RayAll (AT) microsft (DOT) com> wrote

Himanshu,

If the process of sending email is part of DTS package, then you can
add another ActiveX script task and use CDONT object to send email.

Here is the sample,

Dim objMessage
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = strSubject
objMessage.Sender = strFrom
objMessage.From = strFrom
objMessage.To = strTo
objMessage.TextBody = strBody
objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing")
= 2
objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver")
= strMailServerName
objMessage.Configuration.Fields.Update
objMessage.Send

Yunus.