Darren Dick
D.Dick at uws.edu.au
Thu Apr 21 19:05:08 CDT 2005
Hi Stuart Thanks (again) for the reply Firstly, what's RFC 2821? Anyway...It seems to be up and working now I have given my users 2 methods to send emails - depending on what they want to do. Method 1 uses redemption and loops through a recordset and produces an email for each recipient. The second method doesn't use redemption and just creates a big long BCC string Re your comment on a FAN-OUT - have you done this before? If so, how have you done it? RE BLAT - Thanks for the offer - I will contact you off list about Blat :-)) Many thanks Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, 18 April 2005 8:54 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com