I need to pass in an html file and then attach it to the email what is the best way??
This is what I have working ( I just need the attachment)
CREATE PROCEDURE [dbo].[Send_Email_Html]
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
@profile_name = 'GenericEmail',
@recipients = @TO_EMAIL,
@BODY_FORMAT = 'HTML',
@body = @BODY,
@subject = @SUBJECT;