Send EMail Based on Selection using VB Script in Macro

[#1]

Dear All,

          I want to send email from Qlikview using Macro, But My Challenge is how to send email based on Selection. Ex. Given below

Ex.  I have Sales QVW. I have two different Country like South and North. I want  excel sheet as attachment with One Name like All Report.  I have attached Whole Sale details in First Sheet. I want to attach South Sales as Second Sheet and North country as third sheet with the same excel sheet which Whole Sale Report in first Sheet. Please reply ASAP. It is very helpful to me. Thanks in Advance.

Thanks

Sakthivel.S

Gurgaon

[Gysbert_Wassenaar]

Perhaps the code in this discussion can help you: Re: Printing PDF's with a loop

[#3]

Dear gwassenaar

            You mentioned about document reports. This is not i want. I want one Pivot table with three sheets in one Excel file based on Selection. First sheet will be Total Sales, Second sheet will be South Sales, three Sheet will be North Sales. But the Pivot Chart is "CH01".

Thanks,

Sakthivel.S

[Gysbert_Wassenaar]

I did not mention document reports. I pointed out a discussion that contains code that loops through selected values to do something. I thought that was the part you had trouble figuring out.

[#5]

                    I cant understand because your link is purely for PDF. But i need pivot table to Excel with full script.

Thanks,

Sakthivel.S

Gurgaon

[struniger]

Have a look at http://community.qlik.com/docs/DOC-3481

[Ricardo_Gerhard]

You will need to create a VMacro to Export Data like Stefan Truniger mentioned VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Fi... and another config to send e-mail with Qlikview Desktop like this links below:

http://www.toccato.com.br/blog/criando-alertas-para-serem-disparados-pelo-qlikview-server/

Criando alertas para envio por e-mail no Desktop | QlikView no Brasil l Blog da Toccato - Master Res...