Last saved file

Help Studio
, , , , ,
1

Hello
I an downloading attachments from outlook to a specific folder and I need to edit them then re send an email with the attachment
How cab I send the latest excel sheet saved in the folder as an email (latest by date)

thanks

2

Hi @khaled_emad,
You can use For Each File in Folder Activity as below:
image

and if you want to wait till file be downloaded first you can use (Wait for Download) Activity it will wait till file added to download folder location
Please check and update us if you still have issue :slight_smile:

3

thank you man but is there another way than using for each file in folder ?

4

You can use the second option in my comment ( Wait for Download ) activity try it and update us if you still have issue.

5

are you saving multiple attachments from outlook to a folder then you process it but you want to send further by mail just the one most recently saved (latest)?
You could make int32 variable as counter which would increase with each downloaded attachment, add the counter to attachment name during saving then when sending out mail you can attach only the attachment that includes your counter in name.

Would that work for you?

image

6

Actually I am downloading excel sheet from email to a folder edit it and resend it
Once I download another sheet from another email to the same folder location, the folder now will have 2 sheets I need to email the last 1 downloaded

7

@khaled_emad please check below solution and update us if you still face issue.

8

in a loop save your attachment and create a variable:

image
image1264×259 16.9 KB

refer to the variable when processing excel:

image

finally refer to the same variable when sending it out

image

each loop will work only with currently downloaded file, even though there’s more than one in a fodler.