Db_mail

create proc usp_VehicleInsurance as
begin
declare @prv varchar(100)=' '
declare @pra varchar(100)=' ',@vno Varchar(40),@Name varchar(50)
DECLARE @Body VARCHAR(MAX)=''
declare c1 cursor for
select EMIL_ID,Name,V_id from TBL_VEHICLE_INSURANCE order by EMIL_ID
open c1
fetch next from c1 into @pra,@Name,@vno
while(@@FETCH_STATUS=0)
begin
if(@prv <>' ' and @prv <> @pra)
begin
set @Body = @Body + '</Table>'
exec msdb.dbo.sp_send_dbmail @body_format='HTML',  @profile_name='manju',@recipients = @prv , @subject='Your Vhehicle insurence datails' ,@Body=@Body;
end
if @prv <> @pra
set @Body='<TABLE><TR><TH>Name</TH><TH>V_id</TH></TR>'

SET @Body = @Body + '<TR><td>'+@Name+' </td><td>'+@vno+'</td></TR>'
set @prv = @pra
fetch next from c1 into @pra ,@Name,@vno
end
set @Body = @Body + '</Table>'
exec msdb.dbo.sp_send_dbmail @body_format='HTML',  @profile_name='manju',@recipients = @prv , @subject='Your Vhehicle insurence datails' ,@Body=@Body;

close c1
deallocate c1
end