CODEWITHSUNDEEP
phpphpmailer
Vaibhav Kaushal
Vaibhav Kaushal

Reputation: 340

How to not make PHPmailer send an email with multiple 'to' addresses?

I have a table in my database which contains emails to be sent. A script runs periodically as a cron job to read the data from table and dispatch the emails via the SMTP server. I am using PHPMailer for the work here. The script runs a loop for sending emails until all the emails in the table have been sent.

The problem is that most consecutive emails being sent have a common subject. So when the loop runs, somehow all the emails that get sent have a long 'to' list. So basically if 5 email entries (with different to addresses) have the same subject and same content, then it ends up sending only 1 email with 5 addresses (one of each email entry) in the 'to' field. This reveals the email address of every person to everyone else on the list. This is undesirable and the emails must be sent to only that one person for whom it is meant.

I don't know what's at play here. Any suggestions?

Upvotes: 1

Views: 2740

Answers (3)

showkey
showkey

Reputation: 348

while($row = fetch_from_db()) {
   $mailer->AddAddress($row['email']);
   $mailer->send();
   $mailer->ClearAllRecipients()
}

Upvotes: 1

tylerpenney
tylerpenney

Reputation: 239

1st, get the contacts from your db

$contacts = 'GET CONTACTS ARRAY FROM DB'
        if(!empty($contacts)){
            foreach ($contacts as $crt_contact){
               $emails[] = $crt_contact->email ;
            }
        }

2nd use the following to create the "to" field

$to = implode(',', array_unique($emails));

Use the $to to send in mail() function

Upvotes: 0

Marc B
Marc B

Reputation: 360592

Are you doing something like this?

$mailer = new PHPMailer();

while($row = fetch_from_db()) {
   $mailer->AddAddress($row['email']);
   $mailer->send();
}

If so, you need to do a 

$mailer->ClearAllRecipients()

after you send each email, so you start out with a "fresh" To: list.

Upvotes: 2

Related Questions