Hi there,
I currently have a large email list that can go up to 800 users. The list is pulled from a SharePoint list where I keep everything currently using the Office SendEmail to email those users.
However just found out that theres a limitation (on our exchange system) where you can only add 500 users per email.
So i am looking to see if anyone would know of a formula that could send emails by batch.
Something like:
Clear(Email_Batch);
If(
CountRows(Sharepoint_Source) >500,
Collect(Email_Batch, Some_Function_to_get_the-First_500_Entries_VIA_Sharepoint)
Collect(Email_Batch, Some function_to_get_remaining_emails)
ForAll(
Email_Batch,
Office365.SendEmail( User.Email, "SubJect Line","Body Text", { BCC: EMAIL_LIST_FROM_BATCH })
,
Office365.SendEmail( User.Email, "SubJect Line","Body Text", { BCC: Sharepoint_Source})
)
would someone know how to do this?