Try viewing the email body page directly and see if you can spot the problem in the resulting page. I'd have to debug it directly to know.
It could be that the recordset is wrong. It could be the data in the database is wrong. It could be a typo in the column name. Maybe the column isn't in the recordset select statement.