Retrieve data from attachment

[SCO_PP]

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

[geavgous · Accepted solution]

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

[SCO_PP]

Thanks worked like a charm. 

[r96359]

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]

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.

[r96359]

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