EMAIL Tool Error

[dcsramya]

In my formula i have mentioned the path where my report is created and stored 

'P:\Alteryx\Altery Apps\Victory Spend Report VP_MC\'+[Previous Period]+ '_WRKAPVP.xlsx|||Sheet1'

and then I am using the email tool to send the report out. But for some reason it's throwing an error saying it cannot read the file from the location. Am i doing something wrong here. Appreciate any help on this

[alexnajm]

Remove the sheet at the end and the pipes and it should work!

[CeliaC_Silje]

For attachment setup in Email Tool, you just need to include the file path

(think about you are going to send the whole file instead of just a single sheet of the file)

You can insert a Formula Tool before the Email Tool to get rid of the pipes (|) and sheet name in the file path.

[dcsramya]

I have removed the Sheet1 from the Path: 'P:\Alteryx\Altery Apps\Victory Spend Report VP_MC\'+[Previous Period]+ '_WRKAPVP.xlsx'

and the email tool sends out the report., but the problem is i get an error on the report saying you must specify the Sheet name.

The report is scheduled to run 1st of every month for the Previous Period and the email tool will need to find the latest report that is created every month and email that to it's users.

[alexnajm]

You need the path with the sheet name for the output data tool to work, but you also need the path without the sheet name for the email. Put down a Formula tool right before your Email and clear out the sheet name there

[dcsramya]

Inserting a formula tool and using the Regex replace to remove the pipes and sheet name worked. Thanks CeliaC

[dcsramya]

It finally worked Alex using CeliaC's input. Thanks