Can't find files to insert into email

Ok so sometimes in finder I can find files, but mostly not, even if I search by date added/modified etc.

On this particular ocassion, I can find the files in finder, but when I try and insert them into an email, I cannot find it.

Spotlight doesn't find it, it doesn't appear under today's documents.