Assuming that your email solution is working and that your question is "how can I get this information without needing to send it in an email?"
The easiest way would probably be to use the Salesforce-provided Data Loader (or some similar tool). The "export" option allows you to choose an SObject, choose a location and name for the CSV ...
You can export all notes and attachments using open-source sfdx-hardis plugin command
First, define a files export
Then, run the files export
More details in this article
Disclaimer: My company authors sfdx-hardis plugin