I want to set jobinfo 2 = to the results of a recordset.

can someone please show me the correct statement to achieve this?

my recordset is called email and i have already validated that it is recieving the correct information that i need.

Thanks,

Anthony