Sending Email with Dynamic Information from Recordset in Subject Line
I am trying to send an email which loops through a recordset. All of the information from my recordset appears correctly in the email but the subject line only displays the ID reference from the first row of the recordset for each email. Is there a specific line of code I need to use so that I can display dynamic information from a recordset in the subject line of each email?
I've attached my files for you to look at.