Automating pdf attachment process

[avg_acct]

Hello All,
I am looking for assistance in finding a solution for a process I want to automate. Monthly I have to send multiple .pdf files of bank statements to several other co-workers. Can I write code for vba in such a way that it do the following:

*Look in different folders on the shared drive based upon date (ex: Jul 2017, Aug 2017)
*Attach multiple files to the same email (file names are structured 12 character bank prefix_routing #_acct#_MM_DD_YYYY_1)



In doing a google search I a post that allowed for the creation of template for the user to attach one file using vba.

[gmayor]

Whether you are sending the same batch of PDFs to each co-worker or separate sets of PDFs to each co-worker you can do that using http://www.gmayor.com/ManyToOne.htm in one to one mode, provided you setup the Excel file appropriately.