Count how many Excel attachements a MailMessage object has

[alvaro.j.nobre]

Hello there,

I’m trying to count how many xlsx files are in a given AttachmentCollection. I’m trying to apply a filter using the CountOf function like so:

Thank you in advance

[ppr (Peter)]

@alvaro.j.nobre
At least we can do.

With the help of Regex we can handle it more general for the different variations

Messages(0).Attachments.Where(Function (x) Regex.IsMatch(Path.GetExtension(x.Name).ToUpper,Pattern)).Count

Modify the Patterns as by your needs /choice
Use mail instead of Messages(0) in your code

Ensure following: