Hi Everyone,
I have 2 excel file, One excel consists of E-Mail details of the vendor, Another Excel sheet contains payment details of vendor. Now, I have to take the specific e-mail of the vendor & Copy that payment details of vendor from other excel file, The copied details should be added to e-mail & send e-mail …
Example - If vendor is Alroko , then from the other excel sheet. It should Copy the column from A to E & Copied details should send e-mail… E-mail format is also attached for reference
Please, Help me with this by providing a solution… Thanks in advance

