Sending Qlikview table data as E-Mail

[muthukumarbalu]

Hello,

I have following requirement to send qlikview table data as email,

1. Table data need to be dumped into excel sheet (old file deleted for every execution)

2. Dumped excel sheet data need to send as email, Here when there is no data in excel means then it should not attach excel sheet, Instead it should send a mail with comment as " No data available"

Please note i have tried with attached VB Script, which works fine when it has Data, But when it has no data, It's not working.

Please do revert with macro's for to achieve it, Also correct me if anything wrong in script.

Best Regards,

MB

[vikasmahajan]

check this link https://community.qlik.com/thread/74788

Vikas

[andrei_delta]

hi,

maybe this will help?

Creating a Report and Using PDF Distribution - YouTube

[MindaugasBacius · Accepted solution]

I usually do a minor trick in Macros:

SET obj = ActiveDocument.GetSheetObject("info")

control = obj.GetRowCount

IF control > 1 THEN

    send_report vTO, vCC, reportFile, vName

END IF

It do not trigger the send_report function if the Table called info do not have any data.

Still to send a mail with text "No data available" I suggest you trying the Alerts functionality.

[muthukumarbalu]

This works well, Thanks mindaugasbacius