ok this is my Query:

SELECT T3.NoEmpleado AS 'No.Empleado', LTRIM(RTRIM(T3.NombreEmpleado)) + ' ' + LTRIM(RTRIM(T3.ApellidoPaterno)) + ' ' + LTRIM(RTRIM(T3.ApellidoMaterno)) AS 'Nombre Empleado',

T2.IDArea, T2.

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

The Result is:

719 JOSE ASUNCION FIGUEROA ESTRADA 2jose.a.garcia@nidec-motor.com

766 JAIME SALAZAR CORDERO 2jose.a.garcia@nidec-motor.com

10329JAVIER BRISEÑO GARCIA 2jose.a.garcia@nidec-motor.com

10342FLORINA GOMEZ CEPEDA 1osvaldo.santander@nidec-motor.com

10352SANTIAGO FIDENCIO ZUÑIGA HERNANDEZ 1osvaldo.santander@nidec-motor.com

10355MARIA TERESA CERVANTES GUTIERREZ 1osvaldo.santander@nidec-motor.com

10364EDUARDO RIVERA CRUZ 1osvaldo.santander@nidec-motor.com

10372ALVARO MANUEL MARTINEZ LOMAS 1osvaldo.santander@nidec-motor.com

10384ALBERTO FERNANDO DELGADO LOPEZ 1osvaldo.santander@nidec-motor.com

10434SERGIO ISABEL PERALES HERNANDEZ 1osvaldo.santander@nidec-motor.com

I need send by email the next:

in one email:

to: osvaldo.santander@nidec-motor.com

Subject : 'TEST',

Body:

FLORINA GOMEZ CEPEDA

SANTIAGO FIDENCIO ZUÑIGA HERNANDEZ

MARIA TERESA CERVANTES GUTIERREZ

EDUARDO RIVERA CRUZ

ALVARO MANUEL MARTINEZ LOMAS

ALBERTO FERNANDO DELGADO LOPEZ

SERGIO ISABEL PERALES HERNANDEZ

in the Other email:

to: jose.a.garcia@nidec-motor.com

Subject : 'TEST',

Body:

JOSE ASUNCION FIGUEROA ESTRADA

JAIME SALAZAR CORDERO

JAVIER BRISEÑO GARCIA

How can I make this??