I'm sorry the rs subscrtibers recordset is not used in the email, a different recordset is. the advice given previously wont apply, sorry for that.
Can you double click the RS recordset and send a screen shot showing the reordset settings, then click the test button and send a screen shot showing the results please.