Set up a cursor that selects the primary key of all the actions that need to be e-mailed. Then loop through the cursor, storing the primary key value in a variable and using it to filter and identify the rest of the information that needs to be included in the e-mail.