WITH CTE AS
(
SELECT 
  DISTINCT T2.[EMAIL]
FROM dbo.tblCursoArea T1
  INNER JOIN tblArea T2
    ON T2.IDAREA = T1.IDAREA
  INNER JOIN tblEmpleados T3
    ON T3.IdArea = T2.IDArea
WHERE T1.PROGRAMADO = 1 
)
SELECT T2.[EMAIL],
       Notes = STUFF((
                   SELECT CHAR(13) + CHAR(10)  
                          + LTRIM(RTRIM(T3.NombreEmpleado)) 
                          + ' ' + LTRIM(RTRIM(T3.ApellidoPaterno)) 
                          + ' ' 
                          + LTRIM(RTRIM(T3.ApellidoMaterno))
                   FROM dbo.tblCursoArea T1
                     INNER JOIN tblArea T2
                       ON T2.IDAREA = T1.IDAREA
                     INNER JOIN tblEmpleados T3
                       ON T3.IdArea = T2.IDArea
                   WHERE ns.[EMAIL] = c.[EMAIL]
                   ORDER BY ns.NoteSeq
                       FOR XML PATH(''),TYPE).value('.','varchar(max)'),1,2,'') --STUFF removes the preceeding CrLf/CHAR13/10
  FROM CTE c
 ORDER BY [EMAIL];

DECLARE
  @isql VARCHAR(2000),
  @email VARCHAR(64),
  @notes VARCHAR(max)
  
  DECLARE c1 CURSOR FOR SELECT Email,Notes From OurBigger_Query_with_FORXML
  OPEN c1
  FETCH NEXT FROM c1 INTO @email,@notes
  WHILE @@FETCH_STATUS <> -1
    BEGIN
      declare @body1 varchar(4000)
      set @body1 = 'This is a Simple Email Example generated on ' + CONVERT( VARCHAR( 20 ), GETDATE(), 113 ) + 
      '  to demonstrate sending a basic notification' + @notes

      --this assumes a profile was set as "default", so i don't have to explicitly specify which one to use. else you get this error:
      /*
      Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 112
      No global profile is configured. Specify a profile name in the @profile_name parameter.

      */
      EXEC msdb.dbo.sp_send_dbmail 
          --@profile_name='Stormrage DBMail',
          @recipients=@email,
          @subject = 'Simple Email Example',
          @body = @body1,
          @body_format = 'HTML'
          --@body_format = 'TEXT'
   

    
    FETCH NEXT FROM c1 INTO @email,@notes
    END
  CLOSE c1
  DEALLOCATE c1