attach a file automatically to outlook email

[UltimateNeo]

Hello, I have tried to add a file as an attachment. I have the path and want part of the file name to be from column B in a excel spreadsheet.7

Only part of the filename to be searched for and then all files with that data from column B in their filename attached to the email.
In column B it wold be a 5 digit number re.g 41532 and the filename would start T41532

.attachment.Add ("C:\mypath\" & Sheets("Estimate").Range("B" & CustRow).pdf)

Thank you or any help provided