ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   E-mail Excel workbook as hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/183219-e-mail-excel-workbook-hyperlink.html)

Mike Milmoe

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!


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com