Feed result set into a command

["Metz, Zak" <Zak_Metz@xxxxxx>]

Greetings fellow Saturday-hackin' crazies.
 
I need to do an exception join and process each record of the result set with a 
command.
 
To be a bit more detailed, I have a table of e-mail items and another of 
statuses. I need to select the e-mail items that don't have a completion status 
and feed them into Mr. Stone's MAILTOOL.
 
I'd like to do this as "directly" as possible, so I was thinking RUNSQLSTM, but 
is there a simple way to process the result set? Is this where one would use a 
UDF? I'll need to do a bit more than just call the command, such as logging my 
results.
 
Regards,
Zak Metz
. 
  
NOTICE: This E-mail may contain confidential information. If you are not 
the addressee or the intended recipient please do not read this E-mail 
and please immediately delete this e-mail message and any attachments 
from your workstation or network mail system. If you are the addressee 
or the intended recipient and you save or print a copy of this E-mail, 
please place it in an appropriate file, depending on whether 
confidential information is contained in the message.