Get Emails that only have XLSX

[Astearon]

I have tried filtering only emails that have attachments using the Get Email function but i only found examples with “[HasAttachments] = true” however i would like to filter only the mails that have XLSX|XLSM as attachment.

Can anyone help ?

[vr24]

Hi,
In the save attachment activity there is an Filter option give the value as below,
Filter=“.*(.xlsx|.XLSX|.xls|.xls|.xlsm|.xlsb)”make this change in filter option
hope it will helps you,

[PrankurJoshi]

Hi @Astearon,

See below links exactly what you want -

How to save only a specific file type using Save Attachment activity?

Hi, I need to save only excel files from an email attachment. How can do it? I found there is a Filter property in Save Attachments activity? Is that right option to use? If yes, help me with the Syntax to use Filter property.

Download attachments only having extensions .pdf, .xlsx, .docx, .xlsm from Outlook

Hello, I believe part of the above query is answered in few topics and even i got help from few people but it’s not working exactly. My bot should only download attachments having . xlsx, .pdf, .docx, .xlsm from outlook and then save those files in local folder and move those mails to another sub folder in Outlook. If i am not putting any conditions for attachments to be downloaded it’s downloading everything except .xlsm files, so just to avoid confusion i want to filter the downloaded atta…

Thanks,
Prankur

[Astearon]

I need to save the actual e-mail that has the XLS not just the XLS, I’ve also found the save XLS forum posts but they are not what i need.

I will try and apply the filter “.*(.xlsx|.XLSX|.xls|.xls|.xlsm|.xlsb)” to the get emails function and see if it works there

Edit: tried but i get this error " Cannot parse condition. Error at “(”. " so i guess the filter option requires a different syntax ?

[PrankurJoshi]

Once your filter is applied you can use this to save emails

Filter and save Outlook mails

Hi everyone, I am trying to work on creating a sequence with UiPath to automate the task of checking for unread email in Outlook that contains the word ‘Bill/Billing’ etc in the subject or email content. Afterwards, I will need to save any attachments in those emails. I have created a sequence and did some testing on it, however the saving of email does not seem to work. Would appreciate if anyone can provide me with guidance or help me understand! Thanks! SaveEmail.xaml (8.2 …

Save Mail Message

Thanks,
Prankur

[Astearon]

I can save E-mails and i know that you can use the filter on the Save Attachments property but i need to save the actual e-mail that contains the XLSX not just the XLSX.

[aksh1yadav]

Hey @Astearon

Can you look into this Thread post:-

How to save perticular file from outlook, when the attachments contains multiple files

hi @punee Thanks to @andrzej.kniola to guide me on a little doubt. here i am attaching the attached solution for your above problem. OutLookAttachement.xaml (16.1 KB) Let me know feedback of this solution. Regards…!!

and as per your problem find the attached sample:

OutLookAttachement.xaml (16.9 KB)

Regards…!!
Aksh

[Astearon]

Sorry but the xaml was corrupted or something, i get this:

Could not find member ‘CurrentIndex’ in type ‘http://schemas.uipath.com/workflow/activities:ForEach(MailMessage)’. Row: 80, Column: 51
Could not find member ‘CurrentIndex’ in type ‘http://schemas.uipath.com/workflow/activities:ForEach(Attachment)’. Row: 89, Column: 62

[aksh1yadav]

Hey @Astearon

Sorry but the xaml was corrupted or something, i get this:

Regards…!!
Aksh

What version you are using?

[Astearon]

2016.2.6442.

Currently i can only use this one.

[aksh1yadav]

Ok i am using latest one so do on thing download example from my old post and make changes as per my screenshot

There is hardly 2 changes minor one and my old post is having version 2016 build

How to save perticular file from outlook, when the attachments contains multiple files

hi @punee Thanks to @andrzej.kniola to guide me on a little doubt. here i am attaching the attached solution for your above problem. OutLookAttachement.xaml (16.1 KB) Let me know feedback of this solution. Regards…!!

Regards…!!
Aksh

[Manjuts90]

@Astearon Check below workflow and let me know.

attach-------.xaml (8.8 KB)

[Astearon]

It worked! Thank you!