For...Next Loop issue

I wrote a macro for Excel 2003 and 2007 that send e-mail directly from Excel, extracting the address, file to attach and division from three columns. The macro works superbly well, except for the loop which doesn't work at all.

Complete code:

Please Login or Register  to view this content.

As it is now, it adds all attachments to a single e-mail rather than one e-mail for each rows...