Hi currently learning to do some macro in outlook and want to check if anyone here has done this?

I'm trying to create a macro code in outlook

I want the macro to run in a specifc folder in Outlook
The macro will open the latest email in the folder and open the hyperlink (it's a Sharepoint site)
Then I want macro to automatically copy the latest file from Sharepoint and paste it on a Desktop Folder

is this possible via outlook macro?

Note the macro should run every 6 hours

Thanks