Insert range value in email until empty cell

Hey, just going to speak conceptually here, let me know if you need more specific detail.

What I've done in the past is created a range variable, e.g. dim rng as range, set the range to a starting point, e.g. set rng = ThisWorkbook.Sheets("mySheet").Range("A1"), created a while loop that says while rng.value <> "" do this. At the bottom of the while loop set rng = rng.Offset(1, 0) (set down 1 row).

You can reference the value in the range directly as rng.Value, or an offset by rng.Offset(row, col).value

I think that's what you're trying to accomplish here.

You're right in thinking that a loop within a loop is the idea.

EDIT: NO NEED - I've cracked it :-) Rep added

Hi Poizhan,

I'm possibly being incredibly dense, but can you let me know where it would go in my existing code (on the example spreadsheet) please.

I can see the logic of that bit of code, but am really a bit clueless as to where it should go to make it work.

Thank you

MM