Help amending my for loop

Hi,

I have a excel list of client email addresses & reference numbers that my code loops through and sends emails based on this list. In my test excel doc i have 6 rows - my loop is hard coded to loop through this amount of rows. I need to amend my loop to be able to go through any number of rows as i could have 6 rows now but 36 in a weeks time and 56 in a months time - the number of rows will vary. is there loop doe that would work for my requirements?

this is my current code:

Please Login or Register  to view this content.

Thats worked out great - thank you very much

Thanks for the positive feedback , glad having been of some help.