In some cases you want tp publish the result as a CSV-file on e-mail. You can do this by defining following steps in a duty.
- Collect data
- Publish result to VBU database
- Convert to CSV. Use the module JSON converter with output format CSV.
- Send Email
- module - Publisher - send Email
- SMTP connection - select from drop down list (SMTP connection must be defined in Administrator/Connections)
- Recipient - Email addressed divided by comma
- Attachment name- FILENNAME.CSV
Depenting on the data, Excel can format the result in strange format, so it is recommended to use tthe import wizard to Excel