"find" a file in specificed windows folder then email.

[amorrison2006]

Hello

I was looking on the forums for a macro that could lookup within
windows a field value and if that value is found attach the file to an
email and send the email.

So for example. I have the field [invoice_number] in my table.

I firstly want to lookup the customer name from my main table then
lookup within the windows director perhaps using the find command???
The actual invoice file. The invoice files are named the same as the
field except they also include the date in the filename,

Thats why using search might be better. So perhaps if the first 9
characters of the invoice number matches then attached it to the
email???

I hope someone would have some example code of the above....

Please let me know if I dont make sense,

Thanks so much

Andrea