Cyclic printing of e-mails

[wood]

Hello，

I have this table now, how can I send the different contents to the mailboxes corresponding to them via NP?

That is, send rows 1, 2 and 3 to AA@HOTMAIL.COM, and row 4 to BB@HOTMAIL.COM and row 5 to CC@hotmail.com

LINE NO.	Dealer	element	Recipient Email
1	AA	ABC	AA@HOTMAIL.CO
2	AA	ABC123	AA@HOTMAIL.CO
3	AA	ABC123	AA@HOTMAIL.CO
4	BB	EFG	BB@HOTMAIL.CO
5	CC	HIJ	CC@HOTMAIL.CO

[Ruggero_Piccoli]

Hi,

I strongly suggest you to start by reading the Getting Started chapter of the official help site at https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Introduction/Get-started.htm. It has a detailed explanation on how to reach your goal. 

Best Regards,

Ruggero

[Lech_Miszkiewicz]

Hi @wood 

Totaly agree with Ruggeros point. You need to first understand how all components are working in NPrinting to see how your solution can be built. There is no point for us to explain here how the core of NPrinitng works as we would have to re-write hundreds of pages from help site just to explain how it all works.

In nutshell search and read help site to learn following topics:

• create app
• create connection
• create report (here you need to choose template you are willing ot work with)
• create users and filters
• create task and assign users and triggers

Solution you need would be based on user filters so you would need to learn more about it. 

Lastly to manage your expectations note that NPrinitng will not cycle through your table and it will not send an email just based on your table. You will need to create nprinting users with emails you have and assign user filters to them. 

All this is very well and thoroughly described in help site you just have to read it all through.

good luck!

[wood]

Hello, 

First of all, thank you for your replies.I am very familiar with the regular operation of NPrinting, the problem I am encountering is that I have thousands of rows of data in this table, which means that there are thousands of mailboxes receiving data, and each mailbox receives different data. (It's like a company pushes the information on the paystub to each employee, and each employee's mailbox can only receive his/her own information) I can't create thousands of users in NPrinting. I can only use a QLIK variable to push the data to each mailbox in a loop. How should I write this variable? Or how should this process be implemented?

[Lech_Miszkiewicz]

Hi @wood , 

Well - you say: "I can't create thousands of users in NPrinting." - then I have no solution for you. Distribution of reports to users with data specific to users can only be achieved by use of user filters or section access. In either case you must have users in NPrinting created.

So as far as your description goes the only thing you can do is create those 1000s of users. You can obviously automate that by using recipient import process which is also documented on help site: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/Import-Users-Fi...

Highlighted by you variable cannot be used for loop & reduce & send purpose. Data filtering for the users still needs to be based on user-user filter relationship. 

The more advanced way of using variables or alternative emails is when you group reports by "dummy users" - each dummy user (which still has to be created in NPrinitng) represents set of filters and can have sets of filters applied. NPrinitng opens the app, applies set of filters and that the can change concatenated list of emails in Qlik variable so that can be passed to NPrinting and reports will be sent to those emails.

cheers

[Ruggero_Piccoli]

Hi,

You could also create a dummy user for each filter / report and add all the recipients in one of the the Alternate Email separated by comma. Then in the publish task set to use the selected Alternate Email.

Best Regards,

Ruggero