Send multiple emails to one recipients only without duplicate

I have two excel needs to compare. Firstly, in file OBD_No_Data, I need to find which status “a day” in column duration, then I need to compare the “service center” and “vehicle” column of that status.
Next, I need to compare the “service center” column with another Excel (Location for Conves) which is the “Location” column.

If the service center between two Excel is matched, I need to send the email based on the service center, but if the service center is duplicate, I need to send only one email but need to mentioned the vehicle_no of the status also even the service_centre is same.

Location for Conves.xlsx (10.8 KB) OBD_No_Data.xlsx (17.4 KB)

Currently I already complete part matching between two excel and email based on the service center, but the email being send repeatedly even it is same. I really dont have any ideas. I would really appreciate if you guys can help me. Thank you