cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SCO_PP
New Member

Retrieve data from attachment

Hi everyone, I want to retrieve the attachment (xlxs) when a specific email hits my Inbox. I tried >launch Outlook >retrieve mail. But it isn't working.  Can someone help?

 

**The intend is to get  range of data for the attachment

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
geavgous
Microsoft
Microsoft

Hi there, 

 

In case you use Outlook, you could consider using the action under Outlook -> Retrieve email messages from Outlook. This action, among others, offers the ability to select whether you want the attachments saved. 

By selecting the option "Save Attachment", another field will show up asking for the extraction path. 

You may then use this path to access the excel file using all the given actions you will find under the Excel actions folder.

 

Thank you for providing your feedback. Please let me know in case this works for you 🙂

 

Georg

View solution in original post

5 REPLIES 5
geavgous
Microsoft
Microsoft

Hi there, 

 

In case you use Outlook, you could consider using the action under Outlook -> Retrieve email messages from Outlook. This action, among others, offers the ability to select whether you want the attachments saved. 

By selecting the option "Save Attachment", another field will show up asking for the extraction path. 

You may then use this path to access the excel file using all the given actions you will find under the Excel actions folder.

 

Thank you for providing your feedback. Please let me know in case this works for you 🙂

 

Georg

Thanks worked like a charm. 

Hi Georg,

Is there any way to filter the attachments for just xlsx files for example?

I get a lot of jpg signature images etc that I do not want to save.

 

In PA, I would set up a condition step but I don't see how to do that in PA Desktop.

Thanks! 

Henrik_M
Dual Super User
Dual Super User

No filters yet, so you have to use a For each loop to through the files. You can either perform whatever actions you want inside the loop if it is .xlsx, or add the corect files to another list to loop through afterwards.

@Henrik_M Thank you, I'm downloading them into a temp folder, copying only the xls, then removing the temp.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,192)