topic Get Attachments from One Drive link in Product Forum

Get Attachments from One Drive link

José_LuísPereir — Wed, 16 Dec 2020 15:39:22 GMT

Hi,

I've been working with Outlook and reading emails with attachments. However, the Outlook VBO seems to fail when the attachment is a one drive link and not the actual Attachment.

Through VBA and Microsoft Docs I was able to get the "Attachment" but I still can't save it.

Here's the error message: "Unable to save attachment. Cannot perform this action on this type of attachment."

The Attachment is an .xlsx file and the path is correct since I was able to save the whole Email.

Outlook Version: 2013 (Build: 15.0.5285.1000) MSO (15.0.5275.1000) 32 bits

Has anyone had this issue, if so how did you fixed it?

Re: Get Attachments from One Drive link

John__Carter — Thu, 15 Apr 2021 08:29:16 GMT

Hi Jose Luis - I think if the attachments are actually hyperlinks, then the VBO will need new logic (ie a new page) to extract them. The current logic assumes the mail will have files attached, not hyperlinks.

A quick bit of research suggests this is done via Outlook.MailItem.GetInspector.WordEditor.Hyperlinks https://docs.microsoft.com/en-us/office/vba/api/outlook.inspector.wordeditor

Re: Get Attachments from One Drive link

José_LuísPereir — Mon, 19 Apr 2021 10:50:10 GMT

Hi John,

I've managed to extract the hyperlinks, however I still can't download the file as it would launch the sharepoint and open the document online.

Since in Office 365 (for example) you can download directly the documet from the attachment, I think that there should be an option to execute the same task by code, no?