How to send the doc to email as an attachment

Hi, first post here so hope I do it all right!

I have a document, in my document they are 5 sheets. In each sheet there is a hyper link that says "Mail to xxxxx" I want it so that when you click on the hyper link it sends the sheet only, not the workbook, as an attachment in an email to a defined address.

How can I do this?

Originally Posted by royUK

A doc usually refers to a Word Document, Excel uses Workbooks. Which application are you using?

I am using Excel and trying to create a hyperlink that sends the excel sheet to a mail recipient