Send Email from Outlook With Attachment and Folder Location Based on Date

[jaroldizquierdo]

Hi,

I’d like to attach a file to a sequence where the folder location and file name change based on the day. The goal is to grab yesterday’s file which is saved in yesterday’s folder. The file path will look like this:

FilePath\YYYY\MM\DD\FilenameYYYYMMDD.xlsx

I tried the below but get an error saying file path not found.

"FilePath\"+now.adddays(-1).ToString("YYYY")+"\"+now.adddays(-1).ToString("MM")+"\"+now.AddDays(-1).ToString("DD")+"\"+"FileName"+now.AddDays(-1).ToString("YYYYMMDD")+".xlsx"

How can i get the robot to pick up the correct file?

[NIVED_NAMBIAR (NIVED N)]

Hi @jaroldizquierdo
welcome to forum

can u show how the file path looks like?

[jaroldizquierdo]

[NIVED_NAMBIAR (NIVED N)]

In file strcture can u show?

[jaroldizquierdo]

@NIVED_NAMBIAR are you asking for the file path or what i have written for the path?

Simplified actual file path (with some removed confidential information) is below
“C:\Users\Documents\UiPath\2021\05\27\Report_20210527.xlsx”

Here is what I have written:

[NIVED_NAMBIAR (NIVED N)]

Hi @jaroldizquierdo

Can use this path method

“C:\Users\Documents\UiPath"+Now.AddDays(-1).ToString(“yyyy”)+”"+Now.AddDays(-1).ToString(“MM”)+“"+Now.AddDays(-1).ToString(“dd”)+”"+“Report_”+Now.AddDays(-1).ToString(“yyyyMMdd”)+“.xlsx”

[Shubham_Varshney]

hi @jaroldizquierdo ,

Welcome to the community

The error is occurring because you are trying to save the attachment into a folder which doesn’t exist.

To troubleshoot we will need to do path exist and then create path as per that…

Hope this helps

Thanks,
Shubham

[jaroldizquierdo]

Hi @NIVED_NAMBIAR - thanks for getting back but unfortunately it still isnt working. I even tried using the following to test it and I still got the error.

“C:\Users\Documents\UiPath\2021\05\27\Report_”+Now.AddDays(-1).ToString(“yyyyMMdd”)

[jaroldizquierdo]

Hi @Shubham_Varshney - thank you for your response. Does attaching a file save the file? I am not trying to save - simply grab a pre-existing document and attach it to an email and send.

If creating a path exist will help, do you have a walkthrough of what that would look like?

[NIVED_NAMBIAR (NIVED N)]

Hi @jaroldizquierdo
i forget to add the .xlsx at end, kindly check my above response. I had edited the issue

[Shubham_Varshney]

Got it… Check first if the file exist. By doing so you will make sure that the file actually exist before going ahead with attaching it

C:\Users\Documents\UiPath\2021\05\27\Report_”+Now.AddDays(-1).ToString(“yyyyMMdd”)+“.xlsx”

[jaroldizquierdo]

@NIVED_NAMBIAR this appears to be the same method I already tried and unfortunately it still did not work. Thank you for trying.

[jaroldizquierdo]

@Shubham_Varshney Thanks for the response - the file does exist however even when i try this simplified format it does not work

[jaroldizquierdo]

This was actually the solution. When you put the code the "\" did not go through, but it worked. Issues with my original code were capital YYYY for year and forgetting to put a "\" before the file name. Thank you!