Hi,
I don't think this is the problem, as I have just run the same command in my environment....
msdb..SP_SEND_DBMAIL
@RECIPIENTS = 'XXX@XXXXXX.com',
@PROFILE_NAME ='MAIL',
@SUBJECT = 'TEST',
@BODY='TEST',
@BODY_FORMAT = 'HTML',
@file_attachments = 'C:\WWW.sql'
I used a local login and all worked fine.
Have you had a look at your mail profile and sent a test email?
Regards
Peter Gadsby
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk