Problem with group messaging

Hello All,

I have an issue that I would appreciate some input on how to resolve. I have an application that sends notification messages to several groups in the address book. The customer does not want the To: field populated, so only the Bcc: field is populated when the message is sent out to the user community. There is also a quicklist dialog field on the form that selects groups to send the message to. These groups contain nested groups and this is where the problem is. When selecting one or more of the nested groups, I get the error msg ‘Adding entry will cause the list to exceed 64K. Entry not added.’ I understand why this error occurs - when the groups expand prior to the message being sent it is way too much data for the Bcc field to house. Any suggestions or workarounds? Thanks.

Subject: That’s one of the limitations of bcc:

The only solution I have used reliably is to rewrite your app so that it unnests the groups, and sends one mail to each group

Subject: Thanks

Thank you for your response, I appreciate the feedback. Is there any way you can send me a snippet of your code that unnests the groups and sends the mail?

Subject: Don’t have it on me but

something like thisFunction expandNames(names As Variant, server As String) As Variant

    Dim frm As String

    If (IsArray(names)) Then names = Implode(names,|":"|)

   

    frm = | @ExpandNameList("| + server + |" : "names.nsf";"| + names + |" ) ;|

    expandNames = Evaluate(frm)

End Function