I need to send an email to each driver with their own document attached. Let me explain. I have a folder containing all the pdf files to send to each driver. Each pdf file is renamed with the license plate assigned to the driver. On an excel file I have on one column all the license plates and on another column the driver’s email to send the file to. For each email on the excel file, I must then attach the file corresponding to the license plate in the folder.
Can you help me?