Trigger email with same filename

[praneshsapmm]

Hello ,

I have this requirement to send emails . 

Workflow1 Create files with with customer email id as filename .

smiit@xxx.com

karey@yyy.com

Workflow 2 : Need to pick up the above file based on customer name and trigger email to the customer . But while attaching the file to the email , the file need to be same for all customers like reminder.xlsx . How can i do this . 

Thanks

[gautiergodard]

Hello @praneshsapmm 

One way I would recommend solving for this is by generating a temp file within Alteryx (using a render tool) and attaching that file to the email you are looking to send.

See how you would configure the render / email tools below (you would just be creating .xlsx files instead of PDF):

[Felipe_Ribeir0]

Hi @praneshsapmm 

I believe this workflow can solve your problem.

1) I am using python to create a folder with the email name (adapted from here: Create directory if not exists and save the ouput - Alteryx Community)

2)I am saving each Reminder.xlsx inside his own folder

3)Now that i have the individual filepaths and they are different but with the same filename, i can send the email.

[Felipe_Ribeir0 · Accepted solution]

Hi @praneshsapmm 

It worked?