Unanswered

Export data files from Outlook and import it in excel file

(0) Share

Report

Posted on by Pchela

Hello all.

I receive an email from a co-worker every single day. He attaches an excel file. I need to take all the excel files from email, and put all data into one excel file. Is there a workflow perform this?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Power automate. You can filter on the co-worker and other information that is typical for his excel email. Than a for each on the rows of the attachment and add a new row to an existing one. Another way is to save all the items in one location and use power query to make it into one table. It’s up to you and which version you feel most comfortable with

Was this reply helpful? Yes No
Pchela 4 on at

Like (0)

Report

Thank you for your response.
I think I need to do the first method because I receive the email daily, so it needs to be automatically adding new data to excel table.
Would it work if I receive an email, and in the email excel sheet is attached in other attached email. So, basically, the co-worker is just forwarding me emails he is receiving.

Thank you

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Haha what a lovely process. That is probably a bit trickier because it is an attachment within an attachment. I think the easiest way would be to ask your co-worker to send excel files directly

Was this reply helpful? Yes No
Pchela 4 on at

Like (0)

Report

To be honest, I am struggling even with just downloading the files. Ufff.
Is this process would be easier any other way, maybe with code in VBA?

Thank you for your reply!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think Power Automate would be a good way for you. If you would first ask the person to send the file in excel. That makes it all a bit easier. If not, I give it a try tomorrow.

Was this reply helpful? Yes No
kurdshu 2 on at

Like (0)

Report

Try SoftwareImperial OST to PST converter tool to Import Outlook OST data into Excel format
or
Give it a try for .PST outlook file - SoftwareImperial Outlook PST converter tool to export PST to Excel

Was this reply helpful? Yes No
priyanka034 16 on at

Like (0)

Report
Exporting data files from Outlook and import it in excel file can be easily done using the Import/Export feature of MS Outlook. Firstly, users need to install the MS Outlook application. Then, carefully follow the below-mentioned steps for easy and quick transfer of files from Outlook to excel:
Open the MS Outlook app and go to the "File" option.
Select the "Open and Export" option, and click on the Import/Export feature.
Go to the "Export to a file" option and choose Excel or CSV as the file type.
Browse the location to save the resultant file.
Press the "Finish" button.
By following the above steps, users can effortlessly save Outlook data file in excel file format.

Was this reply helpful? Yes No