this is using CDO

set ANSI_NULLS ON

set QUOTED_IDENTIFIER OFF

SET NOCOUNT ON

GO

alter PROCEDURE [dbo].[Test_SendMail_1]

@From varchar(255) ,

@To varchar(255) ,

@Subject varchar(255),

@Body varchar(8000),

...

Below is the complete code of the proc using CDONTS..

set ANSI_NULLS OFF

set QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE SendEmail

(

@From varchar(255)

, @To varchar(8000)

, @Subject varchar(255)

, @Bodyvarchar(8000)

, @cc...

I have to migrate a application which is currently on win 2000 server to win 2003 server, I agree with you that CDONTS.dll has been discontinued, but howcome it is...

IN addition to this..I have a server with win 2003 and there I have a Sp which uses CDONTS to send mail...I have configured everything there but email is not...

Many thanks for the reply.. I managed to get the attachment working.When I execute my SP it sent the email out but at the end it shows the below error...

Hi,

When I tried to use the variable as suggested, the proc just stops to send any mails, though there were no errors this time. Please suggest

declare @OutPutParam int

...