View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Milmoe Mike Milmoe is offline
external usenet poster
 
Posts: 23
Default E-mail Excel workbook as hyperlink

I have a template that has a macro assigned to e-mail me the file. The
template is large and is filling up my inbox. Is there away to create a
macro to send a hyperlink to the file as opposed to the file itself?

Here is the code I have.

ActiveWorkbook.SendMail "myemailaddress"

Thanks!