I have one excel file with keywords(column A) and email(column B). Also I have other excel file with two columns.
I need search the other excel (column A) with keywords from first excel and then copy that row and send mail which is in the some row es correct keyword from first excel.
My keyword(first excel) is error then I need to go in other excel and in the first column I need find all row with that word and then I need a copy that row and send on the email address(first excel) which is in the some row like a keyword.
Is someone have solution how can i do that?