excel vba send mail attached dynamic filename by date format

[toothboy]

Hi all, I am new in VBA, I am trying to attached those files in a folder which their filename start with date format (eg : yyyymmdd_filename1.pdf, yyyymmdd_filename2...etc ), is it possible to attached the file with correct date? says when I run the marco today, it will attached the filename start with "20160601".

here is my code :

AttFile = Dir(fldPath & "20160601*.pdf")
Do While Len(AttFile) > 0
.Attachments.Add fldPath & AttFile
AttFile = Dir

 

[Norie]

That code looks fine to me, the only thing missing is Loop.

Is it not working as expected?