If text then email macro
 

Hey all,

I am looking to create a formula or a macro that will email information from
a row based on whether there is text in a certain cell in that row. And apply
this solution for every row that will contain text in that column.
I've been using Ron de Bruin's macro (VBA code) to set-up the email, which
works perfectly to create individual emails based on the information, but I'm
hoping to have this automated based on whether any text is present or not,
and have this apply to each row.

A possible issue is that the text in this cell is based on information from
another sheet and will not show up on the active sheet until it is entered on
the indexed sheet. Ie.
=IF(ISNA(MATCH(ROW(A1),Main!K:K,0)),"",INDEX(Main! B:B,MATCH(ROW(A1),Main!K:K,0)))

I hope I've explained this well enough...Any help would be appreciated!

Thanks.