VBA in Outlook (Office 365): pull PDF from link in email into a new email

[caazin]

Hello - I receive an email every day with a link that takes to me to folder. That folder houses a PDF I need to share with colleagues. I've asked that the email contain the PDF rather than the link but have been told it will take some time. Is there a way I can run a macro in Outlook to click the link, pull down the pdf into a new email and send out to colleagues? The email comes at the same time to me every weekday. Thanks.

 

[caazin]

I should add - if it matters - the name of the PDF file is stagnant. The name of the link changes each day slightly. Different day/time noted in the link name.