Hi Ramon

I had executed the steps as per instructed in the procedure.

While executing the code:

declare @Body varchar(4000)

select @Body = 'This is a Test Message'

exec...

Thanx Ramon

I had already tried executing the code given in the URL. But it is also not working 🙁

Hi Ankit

I had saved the XPSMTP.DLL in the folder

C:\Program Files\Microsoft SQL Server\MSSQL\BINN\

and then I had excuted the above lines.

My requirement is sending attachments in email through SQL...

I have registered the xpsmtp80.dll using exec sp_addextendedproc and it got registered properly

I have the following code

declare @rc int

exec @rc = master.dbo.xp_smtp_sendmail

@FROM...

I have registered the xpsmtp80.dll using exec sp_addextendedproc and it got registered properly

I have the folowing code

declare @rc int

exec @rc = master.dbo.xp_smtp_sendmail

@FROM...