Re: How to send report out to user by image format?
I've been able to do this and have been using it in multiple apps/reports for a couple of years. As a summary, we use a chart in a Qlikview app and capture it as a image, which gets emailed out to specific people. The same chart is re-used for different people, by using a list box that filters for those people. All this needs to be run via a macro within the macro module in Qlikview. It isnt the most efficient way, but it does the job, basically the app is triggered to open from a windows task scheduler, the data is reloaded, then the filters are applied, then the macro is run, which in our case uses Outlook for each image, (you can have a collection of images per email or just one image). The email is sent and then the macro goes to the next list box option and loops the export part, until it is complete and then the app closes, until next trigger.
Since there are a few steps in play, let us know which one you need help with. A lot of material on the community sites regarding export, macros, etc...
You will have to fine tune the export part, so that it looks good in the email, also quality of the export so that your emails aren't huge, etc.
HTML = "<!DOCTYPE HTML PUBLIC ""-//IETF//DTD HTML//EN"">" & chr(13) & chr(10) HTML = HTML & "<html>" HTML = HTML & "<head>" HTML = HTML & "<meta http-equiv=""Content-Type"" content=""text/html; charset=iso-8859-1"">" HTML = HTML & "<title>Title here</title>" HTML = HTML & "</head>" HTML = HTML & "<body bgcolor=""#FFFFFF"">"
HTML = HTML & "<table border=""1"" cellpadding=""1"" cellspacing=""1"">" HTML = HTML & " <tr>" HTML = HTML & " <td align=""center"" ><img src=""cid:Logo.jpg"" ></td>" HTML = HTML & " </tr>" HTML = HTML & "</table>"
HTML = HTML & "<br><img src=""cid:GraphSales.jpg"" >"