The below code will do the work
USE msdb
EXEC msdb..sp_send_dbmail
@profile_name='Test Cient',
@recipients='receipent1@yopmail.com;receipent2@yopmail.com', @subject='Daily File Report',
@body= 'Please find enclosed the daily file report',
@file_attachments='D:\FileToExport.txt'
The above code will send email using the
sp_send_dbmail of MSDB which will reach to the recipients
receipent1@yopmail.com;receipent2@yopmail.com with the subject as
'Daily File Report' , the body being '
Please find enclosed the daily file report' and a file attachment
'D:\FileToExport.txt'