So trying to create an email, see code below, in particular the red text.
I have data in columns N,O,P. but this can vary each time from 1 row to 30 rows. My example below showing 5 rows.
What im wondering is if somehow i can loop, however many rows there happen to be per macro run...