VB Code to send email with attachments

Hello:

Please refer to attached sheet.
I have data as shown in column K,L,M,N,O.
Column K refers to location of file, column L refers to subfolder and Column M,N,P will have PDF file name.

I need VB Code to check if any file name exist in Cell M1:O14, if so then email those files as attachment to email address in cell in column B thru Outlook.


I have also added Email body content etc in row 18 thur 26

Please let me know if you have any questions.

Thanks.

Riz

You may have already checked here, but if not, it's a great resource for Excel and might be useful to you
http://www.rondebruin.nl/win/section1.htm