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.