I have completed a macro in Excel that will go to a subdirectory, locate a specific pdf file from data in column A, and attach the pdf to an email. The files are kept in folders depending on the content, i.e., some of the files are in the INVOICES folder, some are in the SERVICES folder, some are in the INTERCOMPANY folder. The file will never be located in more than 1 folder.
What I would like the macro to do is find the file and attach it to an email. The macro works if I provide the complete path but I would like to find the file REGARDLESS to the subfolder name within the 2021 INVOICES folder.
Following is the path for the Services directory. There are also monthly subdirectories for INVOICES and INTERCOMPANY.
C:\Users\christma-2\OurYear2Win\Documents\Clorodet\Accounts Receivable\SAP Invoices\2021 Invoices\04-2021 Service Invoices
I would like the macro to look in the subdirectories in the 2021 Invoices folder.
Bookmarks