sending absence list via email

Hi all,

please help me

I have one file "Attedance" - where i update attendance on every current date , p - present, PL or UPL - Leave
And i have another file "Emp Details" which has employee name and employee id.

what i need is,

when I update Attendance file, for the current date for all the employee as PL or UPL.

I want vba code to send mail with "employee name" & "Emp id" on body of mail.
As per details in Emp details excel file.

attached example files.