Can I use a formula URL button to create an email using an email client and redirect to the initial report?

Try using the IOL Technique with this button formula and module.js:

Paste Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=686

Notes:

(1) I did not test this. Any scenario using an <iframe> and/or the mailto protocol needs to be tested as there may be different behaviors between browsers and the user's registered handler for the mailto protocol.

(2) To prevent the mailto protocl opening an empty tab/window it is opened instead in a hidden <iframe>. Very clever if you ask me.

(3) The three asynchronous tasks (1) ?act=API_AddRecord, (2) ?a=dr and (3) mailto: are arranged in the most likely sequence to have them complete one after the other. But the process is not perfect as the mailto process cannot be monitored.