Hi All,
I have searched for a while, but only found bits and pieces of what I need. I don't think it's even worth it to post my spreadsheet.
I want to search through a particular folder, create an email draft with the subject line that same as each sub folder name, attach any files in that sub folder, and then loop through the rest of the sub folders.
Ex: C:/ contains 3 sub folders.
C:/Test1, C:/Test2, C:/Test3
Test1 has 3 Excel files, Test2 contains 4 Excel files, Test3 contains 1 Excel files
The first outlook email draft would have subject "Test1", and would have 3 Excel files attached to it.
I would greatly appreciate any ideas.
Bookmarks