How to get attachments from saved msg file

[tsibilski]

Hi, 

I've got saved a message files .msg on SharePoint. 

I need to get an .xlsx attachment from the latest one. 

Any ideas?

[themistoklis]

Hello @tsibilski ,

I would like to propose a solution but using another Microsoft tool as well.

Depending on the license that you have you can create a flow using MS Power Automate that will save the xlsx attachment from an email to a folder on Sharepoint.

https://powerusers.microsoft.com/t5/Building-Flows/Save-ONLY-excel-attachments-from-mail/td-p/247572

Then using Power Query you can retrieve the latest excel file from the Sharepoint folder. A quick way to do that is:

1. Load all xlsx files

2. Sort them by creation or modified date

3. Keep Top Rows = 1