I am basically just needing to send a hyperlink to a specific group of people each day at the end of my macro. The hyperlink would be based on the path to a network drive & the name of the file I just saved. Below is the macro line saving the file. Instead of emailing the actual spreadsheet...