I have created the login page and I have imported the excel sheet of 10000 email id’s with their password in mysql. I have created the Password by a script.
So, I need to send the password to all users with welcome message and login link.
So could you please give me the solution for how to send a mail to 10000 users with their password at a time?

5 Years
Discussion Span
Last Post by pritaeas

Nobody will just give you the solution. You will at least need to attempt it by yourself first. Google has many tutorials out there. Learning something for yourself that you need to acheive is the best way to learn.

If then you are stuck let us know what exactly you are having trouble with.


You can do this just using PHP and SQL but no one will just give you the code.

I can recommend this link: http://www.htmlgoodies.com/beyond/php/article.php/3855686/PHP-Mailer-Script-Step-by-Step.htm

It takes you through creating a mailer script step by step explaining every step of the way.

You need to connect to your SMTP server and send the emails in a loop. In each loop you are going to need to collect the recipients email address, username and password.

Have fun and good luck!


I think you're looking for something like this (still to be worked out, of course):

for($i=0; $i<count($records); $i++)
    $record = $records[$i];

    // Set data.
    $password = $record['password'];
    // etc...

    // Mail the user his login info.

    // You're done!

Edited by minitauros


@minitauros: Although correct, I don't think most hosts will allow you to send that many emails in such a short period.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.