I Have two excels (mailList, weeklyData_01sep_05sep).
Excel : weeklyData_01sep_05sep:
if column “Dept Code” and “Dept Code_C”, matches then send Header and Matched row to e-mail address defined in mailList(excel).
for Ex: if “AB-00017” matched in both columns(“Dept Code” and “Dept Code_C”),
send “AB-00017” row include headers to steven.c@gmail.com stella.k@gmail.com
Please refer to attached excel, please helpmailList.xlsx (12.4 KB)
weeklyData_01sep_05sep.xlsx (8.4 KB)