I have created a button on Excel which I would like, when clicked, to attach the completed workbook to an email and be sent directly to a mail recipient.

How do I do this? The button has been created and is clickable I just need the process of embedding the/a code to it and what that code is!

Many thanks