While you won't need to e-mail it, you can use the TABCMD portion to download the newest graph(s).

tabcmd get "/views/Wow/SummaryReports.pdf" -f "progressReport.pdf"

Put the TABCMD program into something like Microsoft Scheduler so that it's kicked off every morning (you can also manually reset it). This ensures your new pdf is saved without you having to touch it.

Link the pdf file as an object in your Excel document; your view should now always be to the most recently saved pdf.

Remember, as a dynamic object, you may run into issues with network permissions: if some viewers don't have access to the drive where the pdf is located, they won't be able to view it. Similarly, some security settings may also prevent it from being viewed.