Need Automate email with attachment - Excel

I have a spreadsheet that contains data, I want a macro to filter out data based on a due date within the next 2 days and email that list of transactions to a set group of people. Key data for the report sent by email Column D - Company filter to only be "100" Column O - Due date to be within the next 2 days of today and budget 50$ Column P - Paid to be "0" Column R - Approval to be pending