Get data from 2 Excel

I had attached two excel file now i want like from owner excel bot pick owner name and search in Mail excel and get the data from mail excel against owner and save that data in another excel once all data search in mail against owner system trigger mail to that user and then pick 2nd owner from owner excel and do the same process

Mail.xlsx (11.4 KB)
Owner.xlsx (8.6 KB)

Hi @Puneet_Singh

  1. For loop on Owner excel
  2. Filter datatble on EMail Excel usign currentrow(“Onwername”).ToString . this will get all the mails with that owner
  3. Send the email


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.