Email to many users - limit

Thu, 06 Dec 2012 06:36:32 GMT

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

Re: Email to many users - limit

flipside — Thu, 06 Dec 2012 09:09:16 GMT

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

topic Email to many users - limit in QlikView

Email to many users - limit

Re: Email to many users - limit