View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carmi Carmi is offline
external usenet poster
 
Posts: 5
Default Using a Hyperlink to send a MS Excel Workbook to Recipient

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 InsertHyperlinkEmail 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 FileSend 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.