I checked the Log On As in the Services MMC on the VM that the SQL database sits on.

The Log On As for SQL SERVER and SQL SERVER AGENT is SQLReportingAdminlan.domain.com.

I have given this user SQLReportingAdminlan.domain.com access to the directory that the file that I want to send as an attachment is in.

The user SQLReportingAdminlan.domain.com now has read and execute permissions on C on the relevant VM.

The sendrequest user in dbo.sysmailmailitems is domainSQLReportingAgent.

Exception Message: Cannot send mails to mail server.

A recipient must be specified.).

I think it uses the current user account to send the mail, so I would also confirm your windows account has permissions to the file.

The mail hasnt arrived yet but this has answered my question.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged sql-server database-mail msdb or ask your own question.

Sp_Db_Sendmail Attachment File Is Invalid