Using a Hyperlink to send a MS Excel Workbook to Recipient

C

Carmi

MS Excel - 2003
Hi all,

I would like to know if it is possible to use a hyperlink to send an email
with the file attached, to a recipient using Insert>Hyperlink>Email Address.

I have a spreadsheet into which I am asking the user to enter data. On
completion I would like the user to click on the the hyperlink and the FILE
to be sent to a specific address.

I know the address, subject and body text can all be set but I can not find
any reference to attaching the file.

I know we can use the File>Send To or Code to send the attachment but a
hyperlink seems like a good solution (if I can find a way to include the
file) as it will limit the amount of steps the user has to follow and using
code comes up against Macro security issues.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top