Thanks for this,

I have used the query below:

EXEC master.dbo.xp_sendmail

@recipients = N'name@domain.com',

@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?

Thanks again