topic Re: How to send customised email through QlikView? in QlikView

How to send customised email through QlikView?

Mon, 04 Nov 2013 07:54:56 GMT

I have some data to send through email on post reload with custom html format. Is it possible to send through qlikview??

e.g. i have following product list

I want to send mail having product details with sales

and format should be as :

Product details for Sales<1000

ProductID ProductName Sales

--------------------------------------------

1004 P4 100

1005 P6 500

1006 P7 800

--------------------------------------------

Total Sales:1400 from product having sales<1000

View more details on : <website URL>

Re: How to send customised email through QlikView?

luciancotea — Mon, 04 Nov 2013 08:13:06 GMT

1. Create a chart (straight table) which returns your desired result ( < 1000 )

2. Save the result as a file using macro

3. Using macro, use an email tool like happy mailing : Blat online which can use html formatting and embedding files into email body.

Lucian

Re: How to send customised email through QlikView?

Mon, 04 Nov 2013 08:24:49 GMT

Hi,

1) first you need to parametrize your email : goto Settings / User Preferences / Mail tab

2) Set up an alert : Tools / Alerts

But I do nt know how much HTML you can put there in your text.

Fabrice

Re: How to send customised email through QlikView?

Mon, 04 Nov 2013 09:47:43 GMT

Thanks for your reply Aunez Fabrice...

I am able to send mail successfully but i just want html formatting to send mail.

Re: How to send customised email through QlikView?

Wed, 06 Nov 2013 13:14:24 GMT

Hey i dont want to use macro any possible way to send customised mail with alert only.

Re: How to send customised email through QlikView?

luciancotea — Wed, 06 Nov 2013 15:41:34 GMT

Custom HTML, no.

Re: How to send customised email through QlikView?

Anonymous — Wed, 06 Nov 2013 19:30:20 GMT

Saif

Try having look at a 3rd party bolt on like NPrinting, give it a Google and see what you think.

Best Regards, Bill

Re: How to send customised email through QlikView?

ngulliver — Thu, 07 Nov 2013 09:28:04 GMT

Hi, Saif.

Following Bill's comment, have a look at

http://www.quickintelligence.co.uk/nprinting/

for more information on NPrinting. There is a 45 day free trial of the product available with full functionality.

Regards,

Neil

Re: How to send customised email through QlikView?

Mon, 18 Nov 2013 17:21:47 GMT

Hello Saif,

this is something that also QV Mail and QV Report can solve very easily and effectively.

We have done something similar in the automotive sector for QV report distributing customized reports to 2.000 sales people worldwide in a matter of clicks.

Let me know if you'd like to take a closer look

regards

Simone Stefanini