you are using about 3 different recordsets in the email body, this wont work.
to pull information specific to the person being emailed in the email body, you need to use the same recordset that is used for the to address loop, that is the only recordset that will advance through each record, the other recordsets will not.
Since you are trying to use data from 3 tables, you will need to use a join query to return the related data from each table in one recordset.