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.

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.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com