Hi All,

I am struggling to find the code necessary to do the following (if it actually exists). I would like to share a file (xlsx) that is on onedrive/sharepoint (desktop version) with a specific person i.e through email address. I know how to email a file as an attachment but I would prefer it to be a file saved on onedrive/sharepoint so that I can update it from my end constantly. I need to do this automatically as there are approximately 800 files needing to go to 800 different pupils.

Many thanks in advance for your help.