[AccessD] A2003:Size of an Email String

On 18 Apr 2005 at 16:28, Darren Dick wrote:

> 
> I have discovered if I have about 400 recipients then the email ends up
> in my drafts folder ready to go
> With a big long BCC string - So far so good - The string length of all
> the emails is about 6000 characters ~+or-
> When there is approx 400 Email addresses
> 
> But as soon as I get above that (Say 500 or even 1,100 email addresses)
> the email does not appear in the drafts folder

 Note that RFC 2821 only requires a server to accept 100 recipients.  If 
your list is greater than that, it is quite possible that only the first 
100 will be accepted/delivered by your mail server. Some ISPs are also 
imposing limits below this, in contravention of the RFC, to try to control 
spam runs.

You have a couple of options, one is to send the email with only 100 
recipients each time (a so called "fan-out"). The other is to build your 
messages and send them one at a time by shelling out to a command line 
mailer such as Blat.  I've got a couple of Access apps that use Blat to 
send out 2-3000 emails.

If you want more info on using Blat with Access, contact me off-list.





-- 
Stuart