mass email from access

[Hans]

I have made an access application for an association with over 500 members.
Email addresses of the members are part of the database.
The association would like to be able to send an email to all of the
members.
I made a small piece of vba with shellexecute /mailto and all the email
addresses in a string.
Addresses are seperated by a semicolon. This works fine up to 50 addresses.

when there are more than 50 members with an email address the vba does not
work.
The association does not use outlook: they want to use eudora.

Is there a way to send an email to 500 members in one operation .

Any help wil be appreciated!

Regards
Hans

 

[Douglas J. Steele]

Sounds to me like it's a limitation put into the e-mail client.

 

[John Goodfellow]

You can use the MAPI library with Eudora quite well. There is a section in
the Eudora help file that details how. Give it a look and ask some more
questions.