Workaround for 10mb email attachment limit

[vdix]

Is there a way to compress .xlsx files before adding them as attachment? If so, please share a sample workflow, i have been trying to create a run command but it hasn't worked.

[IraWatt]

Hey @vdix,

I don't know if this would work perfectly but what I would do is use the Block Until Done Tool to do each step of the process:

First Save the Excel File

Second use a zip tool command or use @Aguisande Zip Files Tool - Alteryx Community Tool

Finally using Email Tool to attach the file using a column containing the Zip File address

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[vdix]

I get this error in the run command

Error: Run Command (15): The external program "powershell" returned an error code: 1

[IraWatt]

@vdix which tool is causing this error?

[vdix]

In the powershell I get this error after running the script using powershell:

At C:\Users\AppData\Local\Temp\1\Engine_\Zipscript.ps1:1 char:36
+ $compress=@{ LiteralPath='out.xlsx'CompressionLevel='Fastest' Destina ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~
Unexpected token 'CompressionLevel='Fastest'' in expression or statement.
At C:\Users\AppData\Local\Temp\1\Engine_\Zipscript.ps1:1 char:36
+ $compress=@{ LiteralPath='out.xlsx'CompressionLevel='Fastest' Destina ...
+ ~
The hash literal was incomplete.
At C:\Users\AppData\Local\Temp\1\Engine_\Zipscript.ps1:1 char:103
+ ... sionLevel='Fastest' DestinationPath='out.xlsx\out.xlsx.zip' } Try{ Co ...
+ ~
Unexpected token '}' in expression or statement.
+ CategoryInfo : ParserError: (:) [], ParseException
+ FullyQualifiedErrorId : UnexpectedToken

Could you share a simple workflow using the macro if possible so i could see if i'm not configuring it right?

[AnaKomissaroff]

Was this problem solved:

Error: Run Command (15): The external program "powershell" returned an error code: 1  ??

[apathetichell]

@AnaKomissaroff - that's your system (and probably your permissions). That's not an Alteryx issue.