Attach File to Outlook Based on Partial Criteria file name

[brianfu777]

Dear VBA Gurus, I've been out of the VBA game for many years and having great difficulty...

In the attached, column AA, is the partial name of the file it's trying to attach (aka File Criteria Name), it's trying to find the file that contains the partial criteria name "Appleseed".

I have no idea how to incorporate this name wildcard name loop into the existing codes by the famous "Ron".

Please help, thank you..