EXEC msdb.dbo.sp_send_dbmail
    @recipients			= 'GrahameHorner@thinkpositive.com'
    -- ,@copy_recipients		= 'copy_recipient [ ; ...n ]'
    -- ,@blind_copy_recipients = 'blind_copy_recipient [ ; ...n ]'
    
    -- ,@subject				= 'subject'    
    , @body					= 'test'
    -- , @body_format			= 'body_format'
    -- , @importance			= 'importance'
    --- , @sensitivity			= 'sensitivity'    
    , @query						= 
		'
		--
		SET NOCOUNT ON;
		--
		SELECT    ''BEGIN:VCALENDAR''	
		+ CHAR(13)
		+ ''PRODID:-//PositiveSolutions//Extranet//EN''
		+ CHAR(13)
		+ ''VERSION:1.0''
		+ CHAR(13)
		+ ''METHOD:PUBLISH''
		+ CHAR(13)
		+ ''BEGIN:VEVENT''
		+ CHAR(13)
		+ ''CLASS:PUBLIC''
		+ CHAR(13)
		+ REPLACE(''DESCRIPTION:{appointmentDescription}'',''{appointmentDescription}'',a.appointmentDescription)
		+ CHAR(13)
		+ REPLACE(''DTEND:{appointmentFinish}Z'',''{appointmentFinish}'',REPLACE(REPLACE(CONVERT ( varchar(19), a.appointmentFinish	, 127 ), ''-'', ''''),'':'',''''))
		+ CHAR(13)
		+ REPLACE(''DTSTART:{appointmentStart}Z'',''{appointmentStart}'',REPLACE(REPLACE(CONVERT ( varchar(19), a.appointmentStart	, 127 ), ''-'', ''''),'':'',''''))
		+ CHAR(13)
		+ REPLACE(''LOCATION:{appointmentLocation}'',''{appointmentLocation}'',a.appointmentLocation)
		+ CHAR(13)
		+ ''END:VEVENT''
		+ CHAR(13)
		+ ''END:VCALENDAR''
		FROM
		[Extranet].[dbo].[tblAppointment] a
		'		
    , @attach_query_result_as_file	= 1
    , @query_result_header			= 0
    , @query_result_separator		= 'CHAR(10)+CHAR(13)'
    , @exclude_query_output			= 1	
    , @query_attachment_filename	= 'appointment.ics'