Emailing from a form - upper limit for "To" field lenght?

[Amit]

MS Access 2K, Windows XP
====================
Hi,

I'd like to send an email to people selected from a form using a list. I've
figured it out how to send email using SendObject.

My question has to do with the limit on the number of email addresses that
can be included, or more specifically, limit on the number of characters in
the "To" field.

What's the limit on this? We have more than 1000 people in our database, and
with groups consisting of 300-400 people. Some users were wondering if it is
possible to email their group of people (meaning, sending an email to 400
people). even though I'm not aware of the limits, the high number instantly
raised a red flag!

So, what's the best way to send an email to such a large number of people
from Access? Will SendObject still work? If not, what are my options?

Basically, I've been asked to duplicate an Outlook function (of sending an
email to a list) from within Access.

Thanks for any help.

-Amit



Thanks for any help on this.

-Amit

 

[david epsom dot com dot au]

There probably is a limit to the length of the
BCC field, and it is probably around 1000 chars,
but you can test that.

If it does work, you need Service Pack 3 for Office
2000, and you may have problems with Outlook Security.
You will have to use the BCC field, because many
people won't accept mail with many names in the To
field.

If you are using Exchange, you will have to change
the Exchange settings to allow that many names in
the BCC field.

(david)

 

[Amit]

Hi David,

Thanks for your response. I tested this by adding email addresses in Outlook
"To" field, and I was able to add 500 or so email addresses. So, it seems
like it might not be an issue. Will test it out further.

Cheers,

-amit

 

[James]

Hello

I am using Outlook Express it seems like there is a limit of about 20 odd
email address, the 1000 charecter limit.

Can I extend this? I am using office 2000.

If not is there a way to automaticaly create a mailing list from Access and
send to that?

Regards

James

 

[MWS]

Would you share the code needed to send email. I am trying to get this to
work with no success.

Mitch