topic Re: Send EMail Based on Selection using VB Script in Macro in QlikView

Send EMail Based on Selection using VB Script in Macro

Fri, 13 Jun 2014 10:37:30 GMT

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

Re: Send EMail Based on Selection using VB Script in Macro

Gysbert_Wassenaar — Fri, 13 Jun 2014 11:06:20 GMT

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

Re: Send EMail Based on Selection using VB Script in Macro

Fri, 13 Jun 2014 11:55:42 GMT

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

Re: Send EMail Based on Selection using VB Script in Macro

Gysbert_Wassenaar — Fri, 13 Jun 2014 12:04:57 GMT

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.

Re: Send EMail Based on Selection using VB Script in Macro

Fri, 13 Jun 2014 12:21:58 GMT

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

Thanks,

Sakthivel.S

Gurgaon

Re: Send EMail Based on Selection using VB Script in Macro

struniger — Fri, 13 Jun 2014 12:34:14 GMT

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

Re: Send EMail Based on Selection using VB Script in Macro

Ricardo_Gerhard — Fri, 13 Jun 2014 13:39:53 GMT

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 Field Value 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 Reseller QlikView no Br…