Hello all,
I am trying to do a macro that (1) will create an email, (2) fill the email body with a range from the workbook, (3) save two worksheets as new workbooks and attach them to the email, (4) and then also attach all of the (pdf) files in a specific folder. My problem is with the attachment of the files (step 4, not the ones that are workbooks, I can attach those).
When I try to do a "for each", or a while or a loop, either it attaches only one of the files, or it attaches the same file over and over again.
Please see my code below:
Thank you for your help,
Rui
Bookmarks