How can I do that folder will be automatically added to an email

Help Studio
, ,
1

Hi all

I have different emails to send to different clients. In each email I add zipped folder as attachment.
I managed that the email adress is automatically added from an excel, however how can I automate that the corresponding folder will be added?
figure 1
figure 2

figure 3
figure 3621×723 28.5 KB

Forum Engagement Daily Reports
2

Hi @regi0001

You can use the for each file in a folder to iterate through all the files in the folder. As you need to attach the correct zip folder, i have added a If block which will check the no (eg. 231117) in the zip folder names.

image
image707×666 31.6 KB

When you find the correct match you assign the path of that folder to variable in this case (FullAttachementPath). You can use this variable in your Send mail activity. Keep the mail activity outside the for each loop.
image
image598×510 20.6 KB

Hope this helps :slight_smile:

3

Thank you,

one question if I enter in the if Condition the number e.g. “231117” then he would never add the next folder with the number “231118” right?

4

Yes correct. We can make it dynamic also. You can put a variable in contains condition with unique value for your required folder.

CurrentFile.Name.Contains(Variable)

5

I’m sorry since I’m a beginner, what do you mean with create a variable. So I have to Assign a variable with for eg. “Ausgangsrechnung Nr_” and the number is then variable? or how do i move forward best?

6

Hi @regi0001

When you are using the for each excel row. You can split the Invoice no field in excel to identify the folder & assign it to another variable in this case i have assigned it to InvoiceNoExtracted. (Which will only give the value 231117)

InvoiceNo.Split("_"c).LastOrDefault()

image
image663×562 26.7 KB

That Value we can use in the if condition.

CurrentFile.Name.Contains(InvoiceNoExtracted)

image
image785×240 8.82 KB

Find Attached the Flow For Your Ref:
Excel_Mail_Send.zip (33.5 KB)

Hope this helps :slight_smile:

7

Thank you soooooo much.
It works great.

8

Hi @regi0001

I think you are new to the UiPath Forum. :slight_smile:
You need to accept my reply as solution & not your own. So that it will help others also to find the solution.

Regards,
AJ

9

oh dear
thanks for the info,

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.