Iterating through email attachments

[Androk (Andrei G.)]

How do you go on to iterate through attachments of a mail and download only those that contain a certain text in the name?

Thank you for the help!

LE: I already have a way to iterate thourgh the attachments and check for the naming but I don t know how to save the attachment to folder. (activities need MailMessage object, I need to save Mail.Attachment object)

[pravin_calvin (pravin kumar)]

Hi @Androk

Check with the reference link below!

How to filter outlook attachment file name?

@phoenix123 From outlook filter option, we can’t use filter attachments. After reading mails from outlook using Get Outlook Mail Message activity and will give you output as List of Mail Messages. And then use For Each loop activity to iterate that list of mail messages. ForEach item in mailMessage If item.Attachments.Tostring.Contains(“xlsx”) Then do some tasks Else Skip

Regards

[Androk (Andrei G.)]

Hi, thanks for the general direction but maybe I wasn’t clear enough. Let’s say I have an email with 10 attachments, pdfs, 5 of them contain a certain word in their naming, 5 don’t. I need to download only the 5 that contain that word, from one email.

[Gokul001 (Gokul Balaji)]

HI @Androk

Have a look on the thread to download the attachment based on the value

Download attachments from emails with a specific subject

Guys i am trying to download attachments from emails send to me with a specific subject .Help me as i see no options to dwnload attachments

https://rpageek.com/download-attachment-from-email/#:~:text=For%20example%2C%20get%20emails%20with,Use%20Contains%20method.&text=Inside%20Then%20branch%20drag%20and,to%20download%20the%20email%20attachment.

Regards
Gokul

[Androk (Andrei G.)]

Thanks but I need to check if the name of the attachments contains a certain text not the email subject.

[Gokul001 (Gokul Balaji)]

Hi @Androk

Have a look on the thread

To get the filename of the attachment and process you condition

How to get the filename of attachment?

Hi @igul, If your email contains just one attachment you could use the following code to get its name: attachmentName = CType(item.Attachments.FirstOrDefault, Attachment).Name Kindly check it at the example below: Main.xaml (1.2 KB) Also, please confirm if it’s what you were expecting, otherwise I’ll try to help either way.

Regards
Gokul

[Gokul001 (Gokul Balaji)]

okay so where will be the source of name of the attachments?

you have saved somewhere else or it will be from excel?

[Androk (Andrei G.)]

Not saving the names anywhere, checking while iterating through the attachments, I ve already followed what you suggested, the problem is the activity Save Attachments does not take the type of argument Mail.Attachment it takes Mail.Message. Any solution for that?

[Gokul001 (Gokul Balaji)]

@Androk

checking while iterating through the attachments

That is what iam asking for with what you will be checking any example of the attachment name do you have?

[Androk (Andrei G.)]

I’m checking if the attachment name (they are all pdfs) contains a certain word like “packing”, some contain it some don’t… i just want to download those that do. An email can have 20 such attachments.

[Gokul001 (Gokul Balaji)]

This packing will be anywhere in the attachment name like at start end or middle?

[pravin_calvin (pravin kumar)]

Hi @Androk

Use the below expression in if condition!

item.Attachments.Tostring.Contains(“packing”)

Then use save attachment to save the attachment with only name packing

Regards

[Gokul001 (Gokul Balaji)]

@Androk

Here is the work around try it in your side

• For each mail message
  • For each Attachments in item.attachments
    • Assign “attachmentname” (String) =“packing”
    • If Attachment.Name.Contains(“packing”)
      - Save Attachments pass item as mailMessage and pass your desinaation and in properties use the assigned variable “attachmentname” in filter option

Here is the workflow for your ref

Sequence.xaml (13.1 KB)

Regards
Gokul

[Androk (Andrei G.)]

It’s at the start usually, could use StartsWith to, but Contains should work aswell.

[Androk (Andrei G.)]

I’ve already tried this, and it does not return any message even though some match that, from what I understand item.Attachments.Tostring.Contains(“packing”) works only for extensions.

[Gokul001 (Gokul Balaji)]

Okay try that steps which i provided in your side and let me know
it worked perfectly for me

Regards
Gokul

[Androk (Andrei G.)]

Thanks for all the help and the example.

I managed to resolve it like this:

Seems more elegant to me and works perfectly! Thanks a lot!