Nprinting 17 - How to send to multiple users in one email

[scott_simmons]

I have a report that goes to over 50 people, instead of sending one email to everyone in the group(blows up our smtp server to send all at once), I would like to send one email to all 50.  In Nprinting 16, we could make a user who's email contained a list of emails, this isn't possible in 17.  So how does one make this happen?

[Lech_Miszkiewicz]

Hi,

create a dummy user in NPrinintg (say: distribution.list1@blahblah) and send report from NPrinitng only to this user.

Then in your SMTP server configure distribution list to forward all emails from  distribution.list1@blahblah to your recipients)

[balabhaskarqlik]

May be like this:

One option is:

Just add into one recipient the addresses separated by comma.

like: addr1@test.com,addr2@test.com,...It's for static recipients.

If the recipient list is dynamic, then you will need to schedule a Recipient Import before the Report Task.

If your recipient list is in a QVW, in NPrinting 17.x you can build a chart in the QVW, with the relevant information and import the recipients directly from the chart.

Now combine these two approaches - export recipients with concatenated addresses (one recipient per group) and import these.

[balabhaskarqlik]

Check these links:

https://help.qlik.com/en-US/nprinting/17.3/Content/Recipients&Users/ImportUsersFiltersGroups/Import-...

https://help.qlik.com/en-US/nprinting/17.3/Content/DistributionSchedulesAutomation/HowDistributeUser...

[scott_simmons]

I do not have the rights to change the SMTP server on the Network.

I am using Nprinting 17 and it doesn't allow you to import from a file. Below is the error message

Can not create the new user because their email is invalid. ERROR message : Import task execution failed. No data was saved.

[Lech_Miszkiewicz]

Hi Scott,

What you are saying about NPrinting not allowing you to import users from Excel is not true. NPrinting does allow import from Excel. Error you get only means that you are doing a mistake somewhere - where? - let's have a look...

The official help document provides a template of how users load template needs to look like. You CANNOT CHANGE its structure as it will not work. Also you need to understand what you are doing when importing new users. (For example - if you are trying to load a user who is admin user / NPrinitng service account you might get error as NPrinting will prevent this user from being updated by external load since potentialy it could locke out the NPrinting environment).

It is likely you are not population all required fields or you are making some mistake in user entries.

Your error suggest that email address is not valid. This can mean that you are for example loading the same email address for multiple users, and obviously it is an error since email address should be distinct on user import list.

On the other hand if you don't have access to your smtp - i am sure someone else does..maybe try to contact an admin?

cheers

Lech

[scott_simmons]

Let me clarify, it does allow me to import from a file.  However, it doesn't allow me to import a record in the file that has more than one email in the email field(i.e. a comma separated list or semicolon separated list).

[Lech_Miszkiewicz]

I see - this is because like i said email address needs to be distinct  and valid as it plays role of distinct user id.

Coma separated emails are not allowed!

You can however put multiple emails manually in CC section in Publish task, else i you are left with sugested above options

regards

Lech

[dillerja]

What we ended up doing for this was to have the report send to just one recipient (one of our Qlik Admins) and then in the Publish task on the Email Message tab in the 'To' field change the selection to 'Selected users and CC/BCC'.  Upon selecting that option you are shown the CC and BCC fields.  In those fields you can add a semicolon separated list of recipients.

[Lech_Miszkiewicz]

Jack is Correct - that is exactly what i suggested as a workaround...