Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
April 14, 2005, 10:53 pm
rate this thread
I've made a mysql database with php front end which, in part, contains
mailing lists. I've used a mailto: link to create a new email with
their names in the bcc: field.
Unfortunatley their is a limit on the size of a mailto: field that
outlook can accept, and so it can't be used to mail more than about 80
people at a time. Our lists go up to 200.
Can anyone suggest a workaround that will enable people to follow a
link to a new email populated with addresses?
PS I would like to keep the whole interface web-based
PPS DO I sound like a spammer?!! I promise I'm not.
Cheers for your ideas!
Re: open email client from mysql and php database without using mailto:
Right, you need a more scaleable solution. Outlook isn't the only mail
client that has a finite limit to the number of addressees.
One option is to generate the email as part of your PHP application.
Let the user enter subject, body, and choose the recipient mailing list
from a drop-down list. Then send the email directly from the PHP
Here's an article on how to do that:
You also then have an opportunity to keep a log or an archive of all the
emails as your application sends them.
But PHP isn't the best technology to send bulk email (i.e. sending to
more than a handful of recipients). As mentioned in the article above,
a better way to do this is to maintain a mailing list server yourself,
and then when your users want to email to a list, they are given a
mailto: link to a single address at your server, and that address is
received by the mailing list software, and reflected to the entire list
Here's an FAQ on software to provide mailing lists management:
You might need to write some script to pull the recipients data from the
MySQL database and re-generate the mailing list recipients definitions
as an offline task. Some mailing list managers might even allow you to
skip this step, by taking the lists of recipients directly from a database.
In addition to the industrial-strength software packages listed in that
FAQ, try a google search on: mailing list management mysql php
There seem to be quite a few free solutions available, and many
commercial ones too.
For instance, here are some lists of tools:
- » How to format a database with a field that has a table or list?
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum