I am not sure what you meant automatic, but here is how I created.
When the above chart is created, you can send them to an excel file.
Go to the recipient ->recipient import->From File(this is the file you just created)-> following the instruction of the steps. remember to select the excel file.the at the last step to map the fields.
its a straight process.
Or you can import by entity too.
Hope this helps.
Hi thanks for the response, but not quite what I'm looking for. let me elaborate:
I need to use nPrinting/Qlik to send an email to each of the ASM's at month end. The bit I don't know how to do is, dynamically pick up their email addresses from the data?
From the above example:
Fred Smith get's one email containing a three row spreadsheet showing the spend on his accounts.
John Brown also get's one email containing a three row spreadsheet showing the spend on his accounts.
I have written the reports and scheduled them.... I'm just lacking how to dynamically grab their email addresses.
Your answer and mine have crossed.
So, if you are using nPrinting, no need of the Publisher.
You will have to create recipients (they can be done by a task importing them from your QV application) with recipient's filter.
Those filters will be applied by nPrinting when creating the reports for each recipient.
See this thread Nprinting - Recipients Filters dynamically, you will have useful links.