FETCH FIRST FROM @hCx INTO @recipient,@copymailto,@Subject,@mailbody,@emailid,@filepath

WHILE @@FETCH_STATUS = 0
BEGIN
	IF @recipient is  not null 
	BEGIN

	DELETE tab_ccsnetemailsum WHERE emailid=@emailid

		IF RIGHT(@filepath, 1) = '\'
			BEGIN
				SET @filepath = ''
			END

--Here i want to check if filepath does'nt exist then skip to next.

		
		SET @filepath = REPLACE(REPLACE(@filepath,'.doc','.pdf'),'.rtf','.pdf')

 			EXEC msdb.dbo.sp_send_dbmail
			@profile_name = 'DBMailProfile', 
			@recipients=@recipient, 
			@copy_recipients = @copymailto,
			@body = @mailbody,		
			@subject=@Subject,
			@file_attachments=@filepath
	END

	FETCH NEXT FROM @hCx INTO @recipient,@copymailto,@Subject,@mailbody,@emailid,@filepath
 End