nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can not get the E-mail tool to recongnize a file name

apowers

OK, I have gone through the tutorials, the past posts in the community looking for a solution and I still can not get my report to email. What I am trying to do is e-mail a dynamically named multi-sheet Excel file when the report is done running and the email tool refuses to find the specified file. The report does save correctly with no errors, is saved with the correct name to the correct location. Any assistance would be appreciated. Thank You

Weekly - FM Check_AP.yxmd

Accepted answers

Treyson

I should clarify. Your write out can still have the sheet name portion (which is what I asked you to remove). However the email part only wants to look for the Excel file ending in XLSX. So you could probably throw a formula in there removing the 3 pipes and table name.

All comments

Treyson

So I think that the filename that you are using has "||Adds" on there. Remove that and give it another shot.

If that is still give you problems, try writing it to a temp space. The format would be something like .\FMListUpdates20180525.xlsx for both the write out and the email tool.

The other thing I would try is to make this adjustment with the "wait until done" tool. That way it is 100% finished before it trys to email

apowers

Treyson, thank you for your quick reply. I have tried removing the sheet name "|||Adds" and the corresponding "|||Drops" from the second workflow from the filename but when I do that two things happen, first the file will not save correctly, it will come back saying I need to define the sheet names, and also the file will not save correctly, only one of the workflows is saved in the excel file.

Now for your second recommendation, what do you suggest I do with the second workflow and its Wait until done tool?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15912

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703