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.

  1. Collect data
  2. Publish result to VBU database
  3. Convert to CSV. Use the module JSON converter with output format CSV.
  4. Send Email
    1. module - Publisher - send Email
    2. SMTP connection - select from drop down list (SMTP connection must be defined in Administrator/Connections)
    3. Recipient - Email addressed divided by comma
    4. 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