Problem using loop for sending excel range in email body using Range to HTML code

Hi,

I need to send a range in the body of an email, and need to repeat this process a number of times. For this I am using a standard range to html procedure which I found on the net, to which I have added a for loop:

Please Login or Register  to view this content.

The problem is that, on running the code, only blank emails are created with just the 'To' field populated. The various temp files aren't deleted as well.

The code works perfect when there is no for loop. However when the loop is added, blank emails are created. Can someone help me identify the problem in the code?

Can someone help with this?

Sorry for spamming with this one, but I am absolutely clueless about how to resolve this..