Auto daily orders prepairing to store owner oscommerce

I'm looking for a solution to keep oscommerce admin work to a minimum. I would like the store to automatically send an email each morning. The email contents should be the products from the customers unshipped orders. I need the products split into different categories. The categories will be based our suppliers. For example: In store, unshipped or "prepairing" orders are: order a is for a computer and a monitor order b is for a laptop order c is for a printer order a and c are for supplier 1 order b is for supplier 2 But in order a the printer comes from supplier 3 So the email would look something like this: supplier 1 computer printer supplier 2 laptop supplier 3 printer We use a status called partial shippment - seperate packages, we would need a solution so the partialy shipped products from the customers order, are not included in the daily email.