I tried to your solution with below script. it executes successfully but no message at recipient end. Can you please me

____________________________________________________________________________

EXEC msdb.dbo.sp_send_dbmail

@recipients= 'abc@hotmail.com'

,@copy_recipients= 'xyz@hotmail.com'

,@blind_copy_recipients = 'KLM@hotmail.com'

,@subject= 'Test Meeting'

,@body= 'test by adnan'

-- , @body_format= 'body_format'

--, @importance= 'importance'

--- , @sensitivity= 'sensitivity'

, @query=

'

--

SET NOCOUNT ON;

--

SELECT ''BEGIN:VCALENDAR''

+ CHAR(13)

+ ''PRODID:-//Microsoft Corporation//Outlook 12.0 MIMEDIR//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

[tblAppointmnt] 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'