I’m trying to send emails to school secretaries in my district notifying them of student password resets. There are two CSV files involved:
- The first one is generated by a script (that I've already written). It contains three columns: student's email address, the student's new password, and the school the student belongs to.
- The second one contains only two columns: school, and secretary's email.
Basically, use the second file as a map of the school name to the secretary’s email address. How do I do this?