473,320 Members | 2,041 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

open email client from mysql and php database without using mailto:

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!
Jul 23 '05 #1
2 3799
Nigi wrote:
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.


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
application.

Here's an article on how to do that:
http://www.developer.com/lang/php/ar...0941_3468701_2

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
of recipients.

Here's an FAQ on software to provide mailing lists management:
http://www.faqs.org/faqs/mail/list-admin/software-faq/

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:
http://www.devscripts.com/PHP/Mailing_List/
http://www.createafreewebsite.net/ph...ree-tools.html

Regards,
Bill K.
Jul 23 '05 #2
Hullo Nigi -
I would suggest you utilize a php script called
phpmailer ..
Its great for this type of automation.
hth - mondo regards [Bill]
--
"Nigi" <mi*************@gmail.com> wrote in message
news:4b**************************@posting.google.c om...
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!

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jim | last post by:
I have contact info including email address in MySQL. If I use php to extract them into online directory, can a spambot harvest the address? or does the spambot read the raw php code? I...
1
by: user mysql | last post by:
HELLO FRIENDS. HERE A FANTASTIC NEWS FOR MYSQL WINDOWS USER. READE THIS. The article is grab from www/internetnews/com/ DO YOU THINK THAT IS A GOOD NEWS ? ...
0
by: Unigroup of New York | last post by:
Content-Type: multipart/mixed; boundary="------------C465DF38DCB38DD2AF7117E0" Lines: 327 Date: Tue, 15 Feb 2005 23:36:38 -0500 NNTP-Posting-Host: 24.46.113.251 X-Complaints-To: abuse@cv.net...
13
by: Peter Amberg | last post by:
I would like to create a link on my page that opens the standard e-mail application when someone clicks it. It should have at least the subject preset, better if I could preset the body as well. I...
88
by: Mike | last post by:
Is there a way to determine what a user's default email client is? I read a post from 3 years ago that said no. I guess I'm hoping something has come along since then.
15
by: dixie | last post by:
I have a command to open the Access Options dialogue from code: DoCmd.RunCommand acCmdOptions It also opens the Database Window behind it. Is it possible to open the Options without having...
15
by: tshad | last post by:
I am trying to put an persons email address in a response I am sending another person. I can get it to work by doing the following: message.Body = resumeTop & vbCrLf & vbCrLf & "For Applicant:...
5
by: Usman Jamil | last post by:
Hi I've a class that creates a connection to a database, gets and loop on a dataset given a query and then close the connection. When I use netstat viewer to see if there is any connection open...
23
by: andyoye | last post by:
How can I launch Outlook on users machines when they click a button on a web form (InfoPath)? Thanks
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.