Hyperlinks and Email Attachments

[mfranz]

I have an Excel document which my fellow employees fill out and submit for
approval. I have inserted a hyperlink at the bottom which opens an email
message to a specific email account. Is there a way to have the Excel
document automatically attach to the email? I know that there is the option
under File, Send To, Mail Recipient (As Attachment), but the specific email
address would still need to be inserted. I would prefer if individuals could
just click on one location at the bottom of the document. Any suggestions?

 

[Jason M]

you could run a macro that will execute the file, send to mail recipient
command and link that macro to a button or hyperlink within your document.

 

[TxPride]

you could run a macro that will execute the file, send to mail recipient
command and link that macro to a button or hyperlink within your document.