How to wrote macro to send automatic email to user

[#1]

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.

[jagan]

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.

[#3]

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.

[jagan]

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.

[Anonymous]

Hi Amelia,

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

[chematos]

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