Thanks for this,
I have used the query below:
@recipients = Nfirstname.lastname@example.org',
@query = N'EXEC ComSys..RPT_3_DailyEmail ''17-oct-2008''',
@subject = N'SQL Server Report',
@message = N'Test',
@attach_results = 'TRUE',
@width = 250 ;
and it throws back an error of:
Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
I have since installed outlook on the SQL server and set microsoft outlook to the default mail client but it still displays the error above.
What else have I missed?