Hello,
I found some code on this forum that showed me how to send a Lotus Notes email from MS Access. It works beautifully, with one exception. I am creating an email Student Roster. The email body pulls the Course Title and Course Dates from the database. I also want the related student names to appear in the email. I am looping through my student recordset and the Lotus Notes email body displays the course information and then only the last record of the student information. Is there a way I can get it to print all student records for a related course?
Thanks!
I found some code on this forum that showed me how to send a Lotus Notes email from MS Access. It works beautifully, with one exception. I am creating an email Student Roster. The email body pulls the Course Title and Course Dates from the database. I also want the related student names to appear in the email. I am looping through my student recordset and the Lotus Notes email body displays the course information and then only the last record of the student information. Is there a way I can get it to print all student records for a related course?
Thanks!
