Limit to number of email recipients?

[kiwiora]

Hi There,

Am using the "send mail" event where there are ~2200 recipients in the bcc field. (one email using data from the current record; bcc - collect addresses from across found set)

The database dies every time at this step. Completely shuts down Filemaker.

Is there a known limitation on the number of recipients? I have checked our exchange and the limit is 64,000 so it's not that. Have tested on 2 different computers (XP -v- 7; 9.5 -v- 10) with the same results.

Can successfully export otherwise to different format. (i.e xls)

Thoughts?

TIA

[ddreese]

I don't know how helpful this is but I would consider trying using a script that will populate a global field with all the bcc addresses to see if that works any better.

Maybe the send mail script step doesn't play nice with that amount of data, doing the processing up front (looping through each record, g_bcc = g_bcc & email_address & "; ") may answer the question as to which part is choking.

You could also use a calculated field using list() but you would need to script something anyway, so that would be more of a 'blah' idea.

If you can generate the massive global field fine and it still chokes whenever you plug that in to the bcc field, you could then safely assume it that's at least part of the problem.

Also, are you sending directly via SMTP or through e-mail client?