Move to folder based on file name

[dusto]

I have a task at work and I’m not sure how to do what I want to do. I mail merge tons of letters and must file them into respective folders.

I can move files fine using

Please Login or Register  to view this content.

Now here’s the juicy part.

I have files named 2 ways

AB_######_name.pdf ‘where ###### is unique and
ABC_######_name.pdf ‘ where again ###### is unique


Our folder system is like this:
C:\AB_######_name\Correspondence\ ‘THIS IS THE TARGET FOLDER FOR THE LETTER or
C:\ABC_######_name\Correspondence\ ‘THIS IS THE TARGET FOLDER FOR THE LETTER



The ###### in the Folder Name would be correspond to the PDF filename.

Now how do I go ahead and move the filename to the correct folders. Sometimes the correspondence folder is not created, so I have to create it manually.

[JBeaucaire]

I'm thinking this should work. The function MakeFolders is from my free code site, it will create the folder(s) as needed.

Please Login or Register  to view this content.