It will be highly appreciated if someone could help me modify this code a bit.
I have an excel file where one sheet contains a list of emails and then there are sheets with letters for each of these emails.
I already have a code that creates PDFs from all the sheets (in a dedicated folder).
Now I need excel to loop through the email list (which is listed in the first sheet) and programmatically send an an outlook email to each of the emails, and attach the corresponding PDF file.
I need excel to do this automatically, because I have about 100 files and I need to to this every month (so far this was done manually, and it is a real pain).
Reply With Quote