Loop through rows/columns H and K in filtered table and send emails - Help Please Gurus ;)

Hi there

I need to be able to filter a table , and then send emails to every mail-adress found in columns H and K.

Any bright Ideas ?

I've already got the filtering part down, just need help on the looping through visible cells in the two columns and submit email for each cell containing an email-adress.

Thank you in advance - You guys rock !

Hmm ... Maybe I don't even need the filtering

Maybe it could be done just by looping through column C and for each cell with value > 0 then send email to adress in column H.

But I can't for the life of me get it to work, my code-writing part of brain has a meltdown today it seems

Heeeelp

Think I've found a way to work around it

Will now mark as solved