Zip file

[sachin_td]

I have to extract the data from the database then import it to Excel file and then zip it using securezip and make it password protected and  then mail it.

Please suggest how this can be achieve either using coldfusion or DB?

[BKBK]

Use Coldfusion's cfquery and cfzip, apply the custom tags for Excel and Zip-password from MasRizal and then use cfmail to send the result as an attachment.