You can use python code to send email from notebook with attachment, so if you are comfortable with that... here is stackoverflow post on that

Other alternative is to send result to azure function (http trigger) and use whatever code you want to send email.

You can also use Azure data fatory or logic app or power automate to pick up csv file and add as attachment and send email via office 365.

Excel treats csv's as native format and will render is as table, multi sheet workbook is a different story and that may not be achievable. If this is requrement - direct connection to tables are probably your best bet here.

Also alternative - create a databricks sql dashboard that contains tables, graphs and such, send this on schedule to email - it will produce pdf - but its better than nothing if its just overview the person needs.