none
sp_send_dbmail and multipart emails

    Question

  • Hello,

     

    does anybody knows how to send multipart emails with sp_send_dbmail ?

     

    Thanks a lot

    Monday, September 24, 2007 2:33 PM

Answers

  • There is no provision for multpart email in sp_send_dbmail.

     

    sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]
        [ , [ @recipients = ] 'recipients [ ; ...n ]' ]
        [ , [ @copy_recipients = ] 'copy_recipient [ ; ...n ]' ]
        [ , [ @blind_copy_recipients = ] 'blind_copy_recipient [ ; ...n ]' ]
        [ , [ @subject = ] 'subject' ]
        [ , [ @body = ] 'body' ]
        [ , [ @body_format = ] 'body_format' ]
        [ , [ @importance = ] 'importance' ]
        [ , [ @sensitivity = ] 'sensitivity' ]
        [ , [ @file_attachments = ] 'attachment [ ; ...n ]' ]
        [ , [ @query = ] 'query' ]
        [ , [ @execute_query_database = ] 'execute_query_database' ]
        [ , [ @attach_query_result_as_file = ] attach_query_result_as_file ]
        [ , [ @query_attachment_filename = ] query_attachment_filename ]
        [ , [ @query_result_header = ] query_result_header ]
        [ , [ @query_result_width = ] query_result_width ]
        [ , [ @query_result_separator = ] 'query_result_separator' ]
        [ , [ @exclude_query_output = ] exclude_query_output ]
        [ , [ @append_query_error = ] append_query_error ]
        [ , [ @query_no_truncate = ] query_no_truncate ]
        [ , [ @query_result_no_padding = ] query_result_no_padding ]
        [ , [ @mailitem_id = ] mailitem_id ] [ OUTPUT ]

    Tuesday, September 25, 2007 2:58 PM