How to Send automated mails with attachment files saved in a folder?

Hi Guys,

I have a set of PDF files saved in a local folder saved as their respective employee id. I have an excel sheet with employee ids pointing towards their mail id. i have configured outlook. Can some one help me how to create a macro to send automated emails with their respective attachments.?

I have attached a sample file.

Thanks in advance.