Hello Mayor.

This is fantastic I have tested above code that's brilliant , it has few limitations though. I will be having huge PDF's files like 100 may be and it will save like this ("Sealing Invoice ******- Customer 740000" and Sealing Invoice ***XX- customer 69000" ) so on. can we tweak above code like , any file in the folder that matches with customer number "740000" ignoring entire file name and picking up if file name as customer number "******" ..because my invoices are many but customer IDs are few . for example

I have few files in my folder with below names.

"Sealing Invoice ***XX1- Customer 740000"
"Sealing Invoice ***XX2- Customer 740000"
"Sealing Invoice ***XX3- Customer 740000"
"Sealing Invoice ***XX4- Customer 740000"


so from my excel when I say send it should pick any thing has customer number "740000" in PDF should pick and send to " ***XX.com" like wise so on with another customer numbers too. can that be happened ?. I am sorry if I am asking for more . if this is not possible . any new ideas also appreciated ..