Extracting attachment's name from outlook email

[Ricchch (Ricardo)]

Hello Forum,
I would really appreciated if you could advice me on how:

store in a variable the name of one attachement email that was received in my outlook inbox.

The idea is : i have several emails with attachments. So, i want to extract attachments names in a variable ( because my workflow will save the file in a folder path) and then il will use this variable to be able to save again the attachment with the same name BUT with a diferent extension. That’s the reason i need to store the name in a variable …

any suggestion on how to do it will be much appreciated.
Thanks

[fernando_zuluaga]

Hi @Ricchch

Please check those topic already solved

Get Attachment Names

@dimple.khurana lets assume you want to get a string. give a try on: myAttachements = String.Join(“,”, mailMessage.Attachments.Select(function(x) x.Name).toArray)

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.

Trying to get attachment full name in an email

Hey buddy You were almost done Just we need to change the method used from Path To get the full Filename We need to mention as Path.GetFilename(row(“Attachment File Name”).ToString) Or Without file type and only Filename Path.GetFileNameWithoutExtension(row(“Attachment File Name”).ToString) Cheers @Joe.Osifo

if none of the above helps, then feel free to ask

Regards

[Srini84 (Srinivas Kadamati)]

@Ricchch

The idea is : i have several emails with attachments. So, i want to extract attachments names in a variable ( because my workflow will save the file in a folder path) and then il will use this variable to be able to save again the attachment with the same name BUT with a diferent extension. That’s the reason i need to store the name in a variable …

@Ricchch

You can use For Each activity for the email to run the loop
Now you can choose a string variable and give as
mailMessage.Attachments.Select(function(x) x.Name).toArray()

Hope this may help you

Thanks,
Srini

[Anil_G (Anil Gorthi)]

@Ricchch

You actually have an output already which gives you those

If you want all the attachments from all emails then after this activity use append to list or append to collection and append the data in loop

Cheers

[Nitya1 (Nitya Tomar)]

Hi @Ricchch

1. Use “Get Outlook Mail Messages” activity onto your UiPath workflow.
2. Configure the properties of the “Get Outlook Mail Messages” activity, such as specifying the folder (e.g., Inbox) and output variable to store the retrieved emails.
3. Use a “For Each” loop activity to iterate through each email in the mailMessages.
4. Within the loop, drag and drop the “Save Attachments” activity.
5. Configure the properties of the “Save Attachments” activity, such as specifying the email (e.g., item), the folder path to save the attachment, and the output variable to store the saved attachment (let’s call it attachmentPath).
6. After the “Save Attachments” activity, use an “Assign” activity to store the attachment name in a variable. For example, you can use the following expression: attachmentName = Path.GetFileName(attachmentPath).
7. You can then use the attachmentName variable to save the attachment with a different extension or perform other operations as needed
   .
   I hope it helps.

[Ricchch (Ricardo)]

Thanks @fernando_zuluaga
I will work on that today.
Ricchch

[Ricchch (Ricardo)]

Thanks @Srini84

[Ricchch (Ricardo)]

Thanks @Anil_G

[Ricchch (Ricardo)]

Thanks @Nitya1

[Ricchch (Ricardo)]

Hello @fernando_zuluaga
Thanks for helping.
I tried the third example but i have still problem to make it work
you will see in picture below my workflow, where i have already (it is not shown in the picture) filter email from outlook then:
step 1 : i use a Switch activity to filter by attachement name , just if the include some string patterns)
step2: just a message to control for my tests
step 3: in this activity i just apply for marking as read message
step 4 : just to eliminate color categories in a email
step 5: my main problem : i have problem to save the name of the attachement in a variable…would you help on that…

Thanks,

[Ricchch (Ricardo)]

Hi @Anil_G and thanks for helping,
I am using a Switch scenario to catch an email individually instead of using a list variable (and the attachment target ) to save it. you could find the concept of my workflow here.

I have previously filtered the email by : unread and red category (it is not shown in the picture) then I use a Switch activity to verify string subject matches, then once an email respect that string pattern in subject, i use Get outloot mail message to mark as unread. then set outlook mail categories to erase color categories .
Finally (and heres is my problem) i want to store the name of the attachment in this email into a variable . just to be able to use this name after…

Any advise would be much appreciated.
Thanks

[Anil_G (Anil Gorthi)]

@Ricchch

Mail.attachment.Name is the one which would contain the attachment name right…so why are you using row(“soemyhing”) ?

Am I missing something?

Cheers

[Ricchch (Ricardo)]

Thanks to all of you guys!
Finally, i could store the name in a variable using:
CType(mail.Attachments.FirstOrDefault, Attachment).Name
I tried all the other suggestion but i couldn’t make it work for some reason.
Thank you very much for helping…
Richch