What I am trying to do -
I am trying to write a macro that creates an email, attaches file A from a list and file B from another list, and sends it to 4 recipients that change for each email and set of files. There are 200+ files and 100+ recipients. Each file is different and most of the recipients are different as well. The number of emails i need to send match the data in each row.
For example, row 1 is one email, the files that need to go in it are in row 1 column P and row 1 column Q, the recipients are in row 1 as well in columns T, U, and V, and a constant email that doesn't change in cell W1.
The second email would be row 2, attaching files from column P row 2 and column Q row 2, the recipients for this email would be in row 2 columns T, U, and V, along with the constant email in cell W1.
Etc....
Here is the code i have written that is not working. It continues to loop through the column V and doesn't change the other criterias. Please help me fix the code i have if possible otherwise a solution at all if greatly appreciated.
Bookmarks