This works perfect;
exec msdb.dbo.sp_send_dbmail @profile_name = 'SQLMal'
, @recipients = 'firstname.lastname@example.org'
, @subject = 'Consistency Checks of DEV'
, @File_Attachments c:\ConsistencyChecks\ConsistencyJobOutput.txt'
But if I want to attach the file(like below) from remote location why does it not like, can anyone please let me know why it does not like remote location, I don’t want to create a network drive.