I tried turning off the SQL server Agent on my home machine and sent an email which worked.

EXEC msdb.dbo.sp_send_dbmail @profile_name='database email',

@recipients='GaffneyJ@Eclipseblinds.co.uk',

@subject= 'TEST',

@body=' TEST'

The link below says this is possible. I am not planning to use the SQL server agent only the above query to send the email. If it's 100% not possible i'll ask my manager again if we can get SQL Server Standard.

http://www.sqlservercentral.com/blogs/querying-microsoft-sql-server/2013/09/02/sending-mail-using-sql-server-express-edition/[/url]