Thanks but how should I do this?

Hi Phil,

I changed the login details:

EXEC msdb.dbo.sp_send_dbmail  
    @profile_name =  '***'
    , @recipients = '***'
, @body=...

Correct

I thank you for the advice's but still errors...

Message

Executed as user: ***\administrator. Mail (Id: 160) queued. [SQLSTATE 01000] (Message 0) Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE...

I tried this, get the same issue:

Message

Executed as user: ***\administrator. Mail (Id: 159) queued. [SQLSTATE 01000] (Message 0) Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error...

I have changed the code:

EXEC msdb.dbo.sp_send_dbmail
    @profile_name =  'sql***'
    , @recipients = '*******'
    , @subject = 'queryresultset'
,...