I am using SQL Server 2000. I wanted to send MIME type mail through SQL Mail. So I downloaded xpsmtp80.dll and copied to C:\Program Files\Microsoft SQL Server\MSSQL\Binn\DLL. Then I registered it by exec sp_addextendedproc ‘xp_smtp_sendmail’, ‘xpsmtp80.dll’. I granted permission to public by grant execute on xp_smtp_sendmail to public.Now when I am executing this

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N’MyEmail@MyDomain.com’,
@TO = N’MyFriend@HisDomain.com’,
@subject = N’My first HTML mail’,
@message = N’

This is some HTML content

‘,

@type = N’text/html’
select RC = @rc
go

An error generating stating

ODBC: Msg 0, Level 16, State 1

Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

(1 row(s) affected)

Please anyone help me to sort out this problem.