Running a Macro to send an email based on conditional data

PLAN CHANGED: SEE POST BELOW

Hello all, I was wondering if you can help me with a project I am working on. I have attached an example of what I want the layout to look like.

I work at a wholesale food distributor and we have a certain shelf life on a lot of our products. I have set up a conditionally-formatted file in which I calculate the number of days we have left to ship an item before we have to get rid of it.

What I want to do is run a macro that extracts all items with under 5 days of shelf life into a separate file. This file automatically attaches to my outlook outbox with a certain number of recipients who want to get this data. I want to run this report daily.

Any help on this matter would be greatly appreciated.