Generate path of a file in column and send email as attachment based on a cell value

Hi Team,

The pdfs which were in a folder should go as a attachment (using outlook 2010).

In the excel, with in a against the list of items there is a column named email.
Macro should find the name of the pdf and send the email with the attachment to the email in the cell.

Attaching the file for reference.

Also posted on http://www.vbaexpress.com/forum/show...lue&highlight=

Thanks in advance.
Chaitanya