topic Re: How to wrote macro to send automatic email to user in QlikView

How to wrote macro to send automatic email to user

Fri, 20 Sep 2013 15:55:42 GMT

Hi,

Could anyone help me how to write macro and where to write so that the straight table needs to be send to user email automatically.

Thanks.

Re: How to wrote macro to send automatic email to user

jagan — Fri, 20 Sep 2013 16:04:46 GMT

Hi,

Click Ctrl + M to open Macro window and write the script in it. You can find lot of examples in community. Check below URLs

http://community.qlik.com/message/118515#118515

QlikView Macros – Useful collection | Lucian Cotea

Create a button object and assign Trigger to it

Properties -> External -> Add -> External -> Run Macro and give macro name there.

Hope this helps you.

Regards,

Jagan.

Re: How to wrote macro to send automatic email to user

Fri, 20 Sep 2013 16:17:17 GMT

Hi,

Thanks I wrote the script Export Object to Excel and I reloaded the qvw file manually. Could you tell me where can I see the excel please.

Re: How to wrote macro to send automatic email to user

jagan — Fri, 20 Sep 2013 16:21:37 GMT

Hi,

Can you attach the sample file, that you are working. You don't need to reload the file, you need to assign the Macro name to the Button object.

Regards,

Jagan.

Re: How to wrote macro to send automatic email to user

Anonymous — Fri, 20 Sep 2013 16:48:31 GMT

Hi Amelia,

You could use this http://community.qlik.com/docs/DOC-3772

Re: How to wrote macro to send automatic email to user

chematos — Fri, 20 Sep 2013 18:20:06 GMT

You will see your excel in the path you chose to export it. You will need to allow system access to execute the macro and send the email and I'm assuming that you have programmed a trigger to execute the macro after reload the document

Hope this helps

Regards