I have found a lot of info but not for exactly what I want. I want the code to use the path from the open workbook and insert that path as a link into an outlook message so I can send it to a group. The file path will change daily as the current date is added to the end as seen in this example [S:\coname\Shared\Customer Care\docs\todays list 07-26-2016.xlsm], therefore I do not want to have to hard code the file name into the code.
Thanks
Bookmarks