Macro code should find inv no in folder and send attachhed mail.

Hello,

I want a solution ,Mail id and incoice number are in excel, and same invoice numbers are in folder,so it should find invoice number and send mail with subject which are infront of .
This work is on daily basis and there 500 to 600 invoices, so pls help

Note :- Attachment file which are in folder is of Outlook Item (.msg)