If the code seems incorrect, use F8 as I suggested to investigate what it's doing and determine how it's incorrect.
Looking at your workbook, you need to include the file extension in each file name in column E, F and G. Therefore BOL943034 in E2 should be BOL943034.xls, or BOL943034.txt, or whatever the file extension is.
In the code,
is looking in column 6 (F), however your file name attachment list is in column H, therefore change this to:
Using column letters like this instead of column numbers makes the code easier to understand.
Bookmarks