password protect output excel file and draft the email with protected file

Question

i m looking for a solution which help me protect the output file with password for the file and draft the email with predefined email address attaching the protected file.

1. i have to split the raw file into 10 files and protect all 10 files with password

2. then draft the email by attaching above protected file with email address from the predefined list

please help

TheOC · Answer

hey @Manik

There is a password protected excel sheet output tool on the community, have you been able to use that yet? https://gallery.alteryx.com/#!app/Output-Password-Protected-XLSX/5a9d074e0462d716682045a9 
From what i understand of your problem, you could output this file and then attach it dynamically with an email tool.

Hope this helps!
TheOC