Defining Dynamic variable for attachment in Send email

[Nilishachauhan]

Hi,
I want to send email with attachment having suffix as current date. This attachment is output of SQL which will be generated daily like test_check_1_$FILE_NAME.txt where $FILE_NAME is current date in yyyy-mm-dd format.

In one of the task where I am checking conditions the variable is picked up as I have defined variable value in first step i.e. prepare SQL

In attachment absolute path I have given the path as C:\agent\test_check_1_*.txt
Error- Could nor find a file

[renevanosnabrugge]

Hi, Thanks for you message. The filename does not support wilcards. Did you try to add the variable in the path as well? From: Nilishachauhan ***@***.***> Sent: Tuesday, April 6, 2021 11:18 AM To: renevanosnabrugge/SendEmail-BuildTask ***@***.***> Cc: Subscribed ***@***.***> Subject: [renevanosnabrugge/SendEmail-BuildTask] Defining Dynamic variable for attachment in Send email (#36) Hi, I want to send email with attachment having suffix as current date. This attachment is output of SQL which will be generated daily like test_check_1_$FILE_NAME.txt where $FILE_NAME is current date in yyyy-mm-dd format. In one of the task where I am checking conditions the variable is picked up as I have defined variable value in first step i.e. prepare SQL In attachment absolute path I have given the path as C:\agent\test_check_1_*.txt Error- Could nor find a file — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Frenevanosnabrugge%2FSendEmail-BuildTask%2Fissues%2F36&data=04%7C01%7C%7C24f8baf8744545b1c83708d8f8dcdc3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637532974752572699%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ofYdSKPibZdKC2CsQay3EiMo5FanIOPCZzkueVItq8I%3D&reserved=0>, or unsubscribe<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FABOH2WT2HODCUZLUWDR7N7TTHLGUDANCNFSM42OKW2XQ&data=04%7C01%7C%7C24f8baf8744545b1c83708d8f8dcdc3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637532974752582693%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Qt1ec%2BJqS1Xp6D4R8D2eGrEaNFVaIYJuBR5%2F%2B%2BpM%2FtM%3D&reserved=0>.

[Nilishachauhan]

Sorry for the typo. The path I have given is -C:\agent_work\1435\s\test_check_1_$FILE_NAME.txt. Attached is the error
The path that I have given in previous comment is working actually it is a work around so all the files with name test_check_1_*.txt will be sent in mail. But I want to send the exact file