Create email and attach PDFs from anywhere within a folder and subfolders

[bilbo85]

Hi,

I have the attached code which searches for files within a folder and attaches them to an email. The issue is that it only searches the main folder whereas I need it to search all of the sub folders too. Any suggestions at all please?

Please Login or Register  to view this content.

I think this part needs to be modified somehow but I can't work it out.

Please Login or Register  to view this content.

[vba_php]

ummmm....didn't you already post something about this? I remember your name, and I also remember helping someone else out with looping subdirs. I can't find that thread, however does this help you out?

https://www.excelforum.com/excel-pro...ml#post5399775

the getFolder() method can be used to point to a main dir, and then you can loop the subdirs in it by way of using the subfolders property.

[bilbo85]

Hi, no sorry that wasn't me. I did find this link which seems like it might be what I'm after but I'm not sure how to implement it with my code. https://analystcave.com/vba-dir-func...e-directories/

I just have a list of PDF files in a column that I want to find anywhere within a folder/subfolder and attach them to an email.

[Logit]

.
If it will help you, the following macros have been tested to recursively look through a Folder and its Subfolders for XLSM files (all of them). Perhaps you can edit this to suit your needs ?

Please Login or Register  to view this content.

[vba_php]

As you can see what he did, that's exactly what I said previously that you should be doing. The only difference between what I said and what he just did is that he's using the get folder method and the subfolders collection in the same line of code whereas I told you to do it in two different lines of code but it doesn't matter it accomplishes the same goal