I thought I had figured this out, but I've forgotten how to loop for each row in excel.

Basically, I want to iterate the rows until there is a blank row. Each column, lets say there are three, contains a variable. Each variable will be inserted into an email and when the email has been sent, the row will iterate to the next row to pick up the next set of variables to insert into the next email.

If anyone could help with a "for each" loop, I'd be really grateful.

All the best

Barry