Excel VBA, script to attach two excel file on Outlook and send the mail

There are two books(book 1, book 2). One has to write a code in excel VBA and create macro in book 2 to send the two books (book 1, book 2) as attachment in outlook mail. And give a subject and body, where body should contain data from book 2, ie. filter in pass/fail column for missing data and get the details to be shared inline in the mail.(please see the book 2 for reference).