Not sure if this is what you are looking for, but here’s what I came up with. It has the ability to send an e-mail through outlook via the e-mail button. Also put another macro in that will store the info to the clipboard so that you can paste it in where you need it…. This one is more along the lines of what you asked for! If these do not work for what you need please let us know so that we can try to help adjust the macro to do more along the lines of what you need!
I attached a Sample file to see if this is what you need
Copy to clipboard