• There is a simpler alternative for using Script Task for emailing - just use Execute SQL Task with the following code

    EXEC msdb.dbo.sp_send_dbmail @recipients='name1@example.com;name2@example.com',

    @subject = @Subj,

    @body = @Message,

    @body_format = 'HTML' ;

    Sure - Database Mail must be enabled and configured in advance for instance which used for sp_send_dbmail call

    Regards