Are you using these different session variables to hold the same value? Only if you are holdig the same value in these session variables should you update the entries for them all to be the same.
What is the current result that you are are getting? Is your recordset returning the rows that you need, what are you getting in the email message now with this?