I’m trying to create a process to send out a large amount of emails with attachments.
Basically, I have a folder containing all the files to be sent out in .xlsx format, and each file is to be sent out to a different recipient.
The recipient’s email address are in a standard form, with a format along the lines of “hhXXXt@gmail.com”. The “XXX” refers to the first 3 letters/numbers of the respective .xlsx file.
This process is to be run monthly and the number of items in this folder varies from month to month, as such, how should I go about with going through with this process loop?