Running the query with my test DB, it will currently return 3 records (This is how it looks as received in Outlook):

ASBURY PARK-SIF Brake Tester - Monitor 147571 Lane 1 HD 2013-11-12 15:25:00.0000000

Cape May Computer Failure 147582 Re-Exam 2013-11-14 08:53:23.0000000

Mays Landing Power Cord - Cabinet 147583 Lane 4 LD 2013-11-14 12:44:56.0000000

(3 rows affected)

This is how it looks received in SMS:

ASBURY PARK-SIF Brake Tester - Monitor 147571 Lane 1 HD 2013-11-12 15:25:00.0000000

Cape

I would like to send 1 email to the group for each record in the result set.

Thanks for your taking the time to look at this with me!

Keith