Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Email to many users - limit

Hi

I would like to compose email by using button and mailto action (='mailto:'&Concat(DISTINCT Email,';'))

Unfortunatelly Outlook can take only 82 recipients at once. When I have more recipients the rest of them are excluded from email. Did somebody solve this issue?

Thanks

1 Reply
flipside
Partner - Specialist II
Partner - Specialist II

Hi,

Depending on how many total addresses you have, you could add additional actions and split up the list by an associated ID such as ...

='mailto:' & concat({<EmailID={'<=82'}>} distinct Email,';')

='mailto:' & concat({<EmailID={'>82<=164'}>} distinct Email,';')

='mailto:' & concat({<EmailID={'>164<=246'}>} distinct Email,';') ... and so on


... or by alphabet ...

='mailto:' & concat({<Email={'a*','b*','c*'}>} distinct Email,';')

='mailto:' & concat({<Email={'d*','e*'}>} distinct Email,';') ... and so on

... otherwise I think you may be looking at a macro.

flipside