Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to send customised email through QlikView?

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

Capture.PNG.png

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>

8 Replies
luciancotea
Specialist
Specialist

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

Not applicable
Author

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

Not applicable
Author

Thanks for your reply Aunez Fabrice...

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

Not applicable
Author

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

luciancotea
Specialist
Specialist

Custom HTML, no.

Anonymous
Not applicable
Author

Saif

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

Best Regards,     Bill

ngulliver
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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