How to send email once every day of all approved order numbers of that day?

Hello!

I have been working on a project wherein I have to send the list of all approved order numbers of a particular day as attachments once daily. How can I achieve this?

Thanks.