how can we send Mail using Store Procedure in SQl 2000

 EXEC master.dbo.xp_smtp_sendmail            
    @FROM        = '[email protected]',              
    @FROM_NAME   = '[email protected]',              
    @TO          = @vc_mailto,             
    @replyto     = '',              
    @CC          = '',              
    @BCC         = @bcc_mail,              
    @priority    = 'NORMAL',              
    @subject     = @vc_subject,              
    @message     = @vc_message,              
    @type        = 'text/html',              
    @messagefile = '',                 
    @attachment  = '',              
    @attachments = '',              
    @codepage    = 0,              
    @server      = 'smtpserver'