Macro Help...

[nagarjuna_kotha]

Hi All,

I have one issue on Macro.

my requirement is exporting chats and table to Excel's and sending those excels to divisions_wise,region_wise and branch_wise using macro's.

Exporting Excels and Saving those excel to particular path is successfully done.

To send those files divisions_wise,region_wise and branch_wise its not working at all.

Please tell me how to pick the file from path and sending that file to respective area.

Note:

1.For Division, region and Branch i have only one Email field.

2.For division First i should select Division_Type field and then Email field(Email1).

3.For Region first i i should select Region_Type field,Region_Name field  and then Email field(Email1)

4.For Region first i i should select Branch_Type field,Branch_Name field  and then Email field(Email1).

Thanks in Adv

Naga

[jagan]

Hi,

Check this link for sample macros.

Useful Qlikview Macros

Regards,

Jagan.

[nagarjuna_kotha]

Sorry ,

Its not reaching my requirement.

[jagan]

Hi Nagarjuna,

It has some sample scripts, which may not match exactly you have to modify according to your requirement, it helps you in starting the task.

Regards,

Jagan.

[CELAMBARASAN]

Check the below document for sending email

Sending email from Qlikview