need to send email to 1000 addresses (currently in MS Excel)- what's the best way to do that, create a mail forma and paste ALL 1000 addresses in the TO field?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • NotGiven

    need to send email to 1000 addresses (currently in MS Excel)- what's the best way to do that, create a mail forma and paste ALL 1000 addresses in the TO field?



  • Eric Kincl

    #2
    Re: need to send email to 1000 addresses (currently in MS Excel)- what's the best way to do that, create a mail forma and paste ALL 1000 addresses in the TO field?

    Next time, try writing your message in the body, not in the subject line.
    Also, as a common courtesy, please include your name, or at least your
    handle, and email address. (It is smart to mask your email, such as "me AT
    domain DOT com" so that webcrawlers can't add it to spam lists.) Lastly,
    don't post a question that doesn't have anything to remotely do with PHP,
    to the PHP group. Posting to the proper group will not only get you a
    response faster, it will help keep the group on topic.

    Thanks,


    -Eric Kincl

    Comment

    • PP

      #3
      Re: need to spam 1000 people.

      There is a message body to type in you know.

      The best way is probably export it to a text file, an email address on every
      line, then get the file in php using file() and send an email to each one
      seperately.


      --
      Perfect Partner



      Comment

      • NotGiven

        #4
        Re: need to send email to 1000 addresses (currently in MS Excel)- what's the best way to do that, create a mail forma and paste ALL 1000 addresses in the TO field?

        Perhaps I did not post it correctly or explain myself well. Most people I
        email appreciate putting the question in the subject line so they know what
        I am asking for without reading the entire email. Live & learn.

        I'd like to quickly develop a way send email to about 1000 people using php.
        I thought about exporting the excel file to text then pasting & coding each
        line as an array then looping through the array with mail().

        Do you know of a quicker way?




        "Eric Kincl" <Eric@Kincl.net _NO_SPAM_> wrote in message
        news:3fbbf382@n ews.gvsu.edu...[color=blue]
        > Next time, try writing your message in the body, not in the subject line.
        > Also, as a common courtesy, please include your name, or at least your
        > handle, and email address. (It is smart to mask your email, such as "me[/color]
        AT[color=blue]
        > domain DOT com" so that webcrawlers can't add it to spam lists.) Lastly,
        > don't post a question that doesn't have anything to remotely do with PHP,
        > to the PHP group. Posting to the proper group will not only get you a
        > response faster, it will help keep the group on topic.
        >
        > Thanks,
        >
        >
        > -Eric Kincl[/color]


        Comment

        • Eric Kincl

          #5
          Re: need to send email to 1000 addresses (currently in MS Excel)- what's the best way to do that, create a mail forma and paste ALL 1000 addresses in the TO field?

          NotGiven wrote:
          [color=blue]
          > Perhaps I did not post it correctly or explain myself well. Most people I
          > email appreciate putting the question in the subject line so they know
          > what
          > I am asking for without reading the entire email. Live & learn.
          >
          > I'd like to quickly develop a way send email to about 1000 people using
          > php. I thought about exporting the excel file to text then pasting &
          > coding each line as an array then looping through the array with mail().
          >
          > Do you know of a quicker way?
          >
          >
          >
          >
          > "Eric Kincl" <Eric@Kincl.net _NO_SPAM_> wrote in message
          > news:3fbbf382@n ews.gvsu.edu...[color=green]
          >> Next time, try writing your message in the body, not in the subject line.
          >> Also, as a common courtesy, please include your name, or at least your
          >> handle, and email address. (It is smart to mask your email, such as "me[/color]
          > AT[color=green]
          >> domain DOT com" so that webcrawlers can't add it to spam lists.) Lastly,
          >> don't post a question that doesn't have anything to remotely do with PHP,
          >> to the PHP group. Posting to the proper group will not only get you a
          >> response faster, it will help keep the group on topic.
          >>
          >> Thanks,
          >>
          >>
          >> -Eric Kincl[/color][/color]

          Hey,
          I'm actually doing something to that extent right now. What it does is take
          a string (from a textarea... it simply strips the \n tags so php sees it as
          one huge string) and then it splits that string into an array of arrays.
          (the way it works it could easily stand for rows and columns of an excel
          sheet...) Here is the code I have so far. Keep in mind that I am actually
          working on it this exact moment, and it may not be perfect, it seems to
          work so far though for my means.

          function string2namesArr ay(){
          $Nsep = ";"; // Name separator
          $FLsep = ","; // Last/First name Separator

          if(isset($_REQU EST['names'])){
          $names = $_REQUEST['names'];

          // Compound the string - get rid of newlines, spaces, etc...
          $names = str_replace(" ", "", $names);
          $names = str_replace("\n ", "", $names);
          $names = str_replace("\r ", "", $names);
          // I forget which way it is on windows...
          $names = str_replace("\n \r", "", $names);
          $names = str_replace("\r \n", "", $names);
          $names = str_replace("\t ", "", $names);

          // Strip last ";", if present
          // the last ";" apparently causes an extra array index that is unnessasary
          // BETA CODE
          if(strrpos($nam es, $Nsep) == (strlen($names) - 1)){
          $names = substr($names, 0, (strlen($names) - 1));
          }
          // END BETA CODE

          $namesArray = explode($Nsep, $names); // Split on ";" and make array
          $i = 0;
          while($namesArr ay[$i]){
          // split on "," and make an array inside of index [i]
          // Since there can only be first/last name, make max array length 2
          $namesArray[$i] = explode($FLsep, $namesArray[$i], 2);
          $i++;
          }
          return $namesArray;
          }
          }

          To give you an idea of what this program does, there is a textarea in which
          a person can enter a set of names in the following syntax:
          last, first;
          It then takes this list, and puts it into an array of arrays as follows:
          String = "last, first; last2, first2;"
          Array
          (
          [0] => Array
          (
          [0] => last
          [1] => first
          )

          [1] => Array
          (
          [0] => last2
          [1] => first2
          )

          )
          Newlines etc don't bother it. If you could modify this slightly (I think
          you just have to get rid of the "2" in this line:
          $namesArray[$i] = explode($FLsep, $namesArray[$i], 2);
          And that should do it... Also change the $FLsep and $Nsep to be whatever
          the row/column seperators are in the text file.

          Lastly, don't send multiple e-mails. This takes up a ton of bandwidth on
          your end. CC it, or even better, BCC it so that those being emailed can't
          see the other peoples email addresses. I don't know how to BCC in PHP, or
          even email in PHP. Check php.net for that info.

          Good Luck,


          -Eric Kincl

          Comment

          • NotGiven

            #6
            Re: need to send email to 1000 addresses (currently in MS Excel)- what's the best way to do that, create a mail forma and paste ALL 1000 addresses in the TO field?

            thanks

            "Eric Kincl" <Eric@Kincl.net _NO_SPAM_> wrote in message
            news:3fbc0ad9@n ews.gvsu.edu...[color=blue]
            > NotGiven wrote:
            >[color=green]
            > > Perhaps I did not post it correctly or explain myself well. Most people[/color][/color]
            I[color=blue][color=green]
            > > email appreciate putting the question in the subject line so they know
            > > what
            > > I am asking for without reading the entire email. Live & learn.
            > >
            > > I'd like to quickly develop a way send email to about 1000 people using
            > > php. I thought about exporting the excel file to text then pasting &
            > > coding each line as an array then looping through the array with mail().
            > >
            > > Do you know of a quicker way?
            > >
            > >
            > >
            > >
            > > "Eric Kincl" <Eric@Kincl.net _NO_SPAM_> wrote in message
            > > news:3fbbf382@n ews.gvsu.edu...[color=darkred]
            > >> Next time, try writing your message in the body, not in the subject[/color][/color][/color]
            line.[color=blue][color=green][color=darkred]
            > >> Also, as a common courtesy, please include your name, or at least your
            > >> handle, and email address. (It is smart to mask your email, such as[/color][/color][/color]
            "me[color=blue][color=green]
            > > AT[color=darkred]
            > >> domain DOT com" so that webcrawlers can't add it to spam lists.)[/color][/color][/color]
            Lastly,[color=blue][color=green][color=darkred]
            > >> don't post a question that doesn't have anything to remotely do with[/color][/color][/color]
            PHP,[color=blue][color=green][color=darkred]
            > >> to the PHP group. Posting to the proper group will not only get you a
            > >> response faster, it will help keep the group on topic.
            > >>
            > >> Thanks,
            > >>
            > >>
            > >> -Eric Kincl[/color][/color]
            >
            > Hey,
            > I'm actually doing something to that extent right now. What it does is[/color]
            take[color=blue]
            > a string (from a textarea... it simply strips the \n tags so php sees it[/color]
            as[color=blue]
            > one huge string) and then it splits that string into an array of arrays.
            > (the way it works it could easily stand for rows and columns of an excel
            > sheet...) Here is the code I have so far. Keep in mind that I am[/color]
            actually[color=blue]
            > working on it this exact moment, and it may not be perfect, it seems to
            > work so far though for my means.
            >
            > function string2namesArr ay(){
            > $Nsep = ";"; // Name separator
            > $FLsep = ","; // Last/First name Separator
            >
            > if(isset($_REQU EST['names'])){
            > $names = $_REQUEST['names'];
            >
            > // Compound the string - get rid of newlines, spaces,[/color]
            etc...[color=blue]
            > $names = str_replace(" ", "", $names);
            > $names = str_replace("\n ", "", $names);
            > $names = str_replace("\r ", "", $names);
            > // I forget which way it is on windows...
            > $names = str_replace("\n \r", "", $names);
            > $names = str_replace("\r \n", "", $names);
            > $names = str_replace("\t ", "", $names);
            >
            > // Strip last ";", if present
            > // the last ";" apparently causes an extra array index[/color]
            that is unnessasary[color=blue]
            > // BETA CODE
            > if(strrpos($nam es, $Nsep) == (strlen($names) - 1)){
            > $names = substr($names, 0, (strlen($names) - 1));
            > }
            > // END BETA CODE
            >
            > $namesArray = explode($Nsep, $names); // Split on ";" and[/color]
            make array[color=blue]
            > $i = 0;
            > while($namesArr ay[$i]){
            > // split on "," and make an array inside of index[/color]
            [i][color=blue]
            > // Since there can only be first/last name, make[/color]
            max array length 2[color=blue]
            > $namesArray[$i] = explode($FLsep, $namesArray[$i],[/color]
            2);[color=blue]
            > $i++;
            > }
            > return $namesArray;
            > }
            > }
            >
            > To give you an idea of what this program does, there is a textarea in[/color]
            which[color=blue]
            > a person can enter a set of names in the following syntax:
            > last, first;
            > It then takes this list, and puts it into an array of arrays as follows:
            > String = "last, first; last2, first2;"
            > Array
            > (
            > [0] => Array
            > (
            > [0] => last
            > [1] => first
            > )
            >
            > [1] => Array
            > (
            > [0] => last2
            > [1] => first2
            > )
            >
            > )
            > Newlines etc don't bother it. If you could modify this slightly (I think
            > you just have to get rid of the "2" in this line:
            > $namesArray[$i] = explode($FLsep, $namesArray[$i], 2);
            > And that should do it... Also change the $FLsep and $Nsep to be whatever
            > the row/column seperators are in the text file.
            >
            > Lastly, don't send multiple e-mails. This takes up a ton of bandwidth on
            > your end. CC it, or even better, BCC it so that those being emailed can't
            > see the other peoples email addresses. I don't know how to BCC in PHP, or
            > even email in PHP. Check php.net for that info.
            >
            > Good Luck,
            >
            >
            > -Eric Kincl[/color]


            Comment

            • Nikolai Chuvakhin

              #7
              Re: need to spam 1000 people

              "NotGiven" <noname@nonegiv en.net> wrote in message
              news:<1BRub.430 $zi3.301@bignew s3.bellsouth.ne t>...[color=blue]
              >
              > need to send email to 1000 addresses (currently in MS Excel)-
              > what's the best way to do that, create a mail forma and paste
              > ALL 1000 addresses in the TO field?[/color]

              Assuming your mailing is properly solicited, the "To: " field
              should contain only one address, yours (just so that you can
              confirm that the message has in fact been sent). Recipient's
              addresses should go into the "Bcc: " field, separated by commas.
              This way, the size of outgoing message will be smaller, plus
              the receipients won't see who else received the mailing.

              As to "the best way", you forgot to tell us one thing: the best
              way to do WHAT? One-time mailing? Occasional mailings with
              human-generated content? Periodic mailings with database-
              generated content? Something else?

              Cheers,
              NC

              Comment

              • J.O. Aho

                #8
                Re: need to spam 1000 people

                Nikolai Chuvakhin wrote:[color=blue]
                > "NotGiven" <noname@nonegiv en.net> wrote in message
                > news:<1BRub.430 $zi3.301@bignew s3.bellsouth.ne t>...
                >[color=green]
                >>need to send email to 1000 addresses (currently in MS Excel)-
                >>what's the best way to do that, create a mail forma and paste
                >>ALL 1000 addresses in the TO field?[/color]
                >
                >
                > Assuming your mailing is properly solicited, the "To: " field
                > should contain only one address, yours (just so that you can
                > confirm that the message has in fact been sent). Recipient's
                > addresses should go into the "Bcc: " field, separated by commas.
                > This way, the size of outgoing message will be smaller, plus
                > the receipients won't see who else received the mailing.[/color]

                Good to know that that kind of spam won't reach me, as SMTP is blocking BCC
                mail, checking that the to address is really a user on the system to where the
                mail is sent.

                [color=blue]
                > As to "the best way", you forgot to tell us one thing: the best
                > way to do WHAT? One-time mailing? Occasional mailings with
                > human-generated content? Periodic mailings with database-
                > generated content? Something else?[/color]

                Just looking at the topic, seems to be one time spam and spam ain't nothing
                that people wants to have.


                //Aho

                Comment

                • Don Adams

                  #9
                  Re: need to spam 1000 people.

                  [color=blue]
                  > The best way is probably export it to a text file, an email address on[/color]
                  every[color=blue]
                  > line, then get the file in php using file() and send an email to each one
                  > seperately.[/color]

                  I've done this when running PHP as a command-line program
                  using telnet; however, I need to run the same program on a server with
                  only ftp access. When I run the program as a web page, the connection
                  times out before all of the E-mails are sent. So, I have no idea if
                  it made it through the list or not.

                  --
                  Don Adams


                  Comment

                  • Tim Van Wassenhove

                    #10
                    Re: need to spam 1000 people.

                    On 2003-11-20, Don Adams <dga@sgi.com> wrote:[color=blue]
                    >[color=green]
                    >> The best way is probably export it to a text file, an email address on[/color]
                    > every[color=green]
                    >> line, then get the file in php using file() and send an email to each one
                    >> seperately.[/color]
                    >
                    > I've done this when running PHP as a command-line program
                    > using telnet; however, I need to run the same program on a server with
                    > only ftp access. When I run the program as a web page, the connection
                    > times out before all of the E-mails are sent. So, I have no idea if
                    > it made it through the list or not.[/color]

                    user@host: man screen

                    Or write a little resume function.

                    --
                    verum ipsum factum

                    Comment

                    • J.O. Aho

                      #11
                      Re: need to spam 1000 people.

                      Don Adams wrote:[color=blue][color=green]
                      >>The best way is probably export it to a text file, an email address on[/color]
                      >
                      > every
                      >[color=green]
                      >>line, then get the file in php using file() and send an email to each one
                      >>seperately.[/color]
                      >
                      >
                      > I've done this when running PHP as a command-line program
                      > using telnet; however, I need to run the same program on a server with
                      > only ftp access. When I run the program as a web page, the connection
                      > times out before all of the E-mails are sent. So, I have no idea if
                      > it made it through the list or not.[/color]

                      As webservers has a timeout limit and the php.ini has one too, which makes
                      that scripts that takes to long without making any output will be timed out
                      and not preform the whole spamming.

                      Using Bbc: will increase the sped as you only send one mail, but luckylly SMTP
                      servers starts to filter away Bbc: mails, as thise are today used mostly only
                      by spammers (during a month 97% of all spam I got was Bbc:).


                      //Aho

                      Comment

                      • jn

                        #12
                        Re: need to spam 1000 people.

                        "J.O. Aho" <user@example.n et> wrote in message
                        news:bpj6m9$1o3 lfb$1@ID-130698.news.uni-berlin.de...[color=blue]
                        > Don Adams wrote:[color=green][color=darkred]
                        > >>The best way is probably export it to a text file, an email address on[/color]
                        > >
                        > > every
                        > >[color=darkred]
                        > >>line, then get the file in php using file() and send an email to each[/color][/color][/color]
                        one[color=blue][color=green][color=darkred]
                        > >>seperately.[/color]
                        > >
                        > >
                        > > I've done this when running PHP as a command-line program
                        > > using telnet; however, I need to run the same program on a server with
                        > > only ftp access. When I run the program as a web page, the connection
                        > > times out before all of the E-mails are sent. So, I have no idea if
                        > > it made it through the list or not.[/color]
                        >
                        > As webservers has a timeout limit and the php.ini has one too, which makes
                        > that scripts that takes to long without making any output will be timed[/color]
                        out[color=blue]
                        > and not preform the whole spamming.
                        >
                        > Using Bbc: will increase the sped as you only send one mail, but luckylly[/color]
                        SMTP[color=blue]
                        > servers starts to filter away Bbc: mails, as thise are today used mostly[/color]
                        only[color=blue]
                        > by spammers (during a month 97% of all spam I got was Bbc:).
                        >
                        >
                        > //Aho
                        >[/color]

                        Good thing you can set the max_execution_t ime to "0" in an .htaccess file or
                        from within PHP :)


                        Comment

                        • NotGiven

                          #13
                          Re: need to spam 1000 people

                          Right - it's a one time emailing to a known group of 1000 people. The email
                          addresses are curently in Excel.



                          "Nikolai Chuvakhin" <nc@iname.com > wrote in message
                          news:32d7a63c.0 311191833.5d28a 5ac@posting.goo gle.com...[color=blue]
                          > "NotGiven" <noname@nonegiv en.net> wrote in message
                          > news:<1BRub.430 $zi3.301@bignew s3.bellsouth.ne t>...[color=green]
                          > >
                          > > need to send email to 1000 addresses (currently in MS Excel)-
                          > > what's the best way to do that, create a mail forma and paste
                          > > ALL 1000 addresses in the TO field?[/color]
                          >
                          > Assuming your mailing is properly solicited, the "To: " field
                          > should contain only one address, yours (just so that you can
                          > confirm that the message has in fact been sent). Recipient's
                          > addresses should go into the "Bcc: " field, separated by commas.
                          > This way, the size of outgoing message will be smaller, plus
                          > the receipients won't see who else received the mailing.
                          >
                          > As to "the best way", you forgot to tell us one thing: the best
                          > way to do WHAT? One-time mailing? Occasional mailings with
                          > human-generated content? Periodic mailings with database-
                          > generated content? Something else?
                          >
                          > Cheers,
                          > NC[/color]


                          Comment

                          • Nikolai Chuvakhin

                            #14
                            Re: need to spam 1000 people

                            "NotGiven" <noname@nonegiv en.net> wrote in message
                            news:<VOBvb.165 1$6c3.1461@bign ews1.bellsouth. net>...[color=blue]
                            >
                            > it's a one time emailing to a known group of 1000 people.
                            > The email addresses are curently in Excel.[/color]

                            Then why bother with PHP at all? Copy the Excel column
                            of e-mail addresses to Clipboard, paste it into any text
                            editor that can find end-of-line characters (incidentally,
                            Word will do), replace end-of-line characters with ', '
                            (comma plus space), copy to Clipboard again, and paste into
                            the "Bcc: " field of your regular e-mail software...

                            Cheers,
                            NC

                            Comment

                            • Terence

                              #15
                              Re: need to spam 1000 people

                              Nikolai Chuvakhin wrote:
                              [color=blue]
                              > "NotGiven" <noname@nonegiv en.net> wrote in message
                              > news:<VOBvb.165 1$6c3.1461@bign ews1.bellsouth. net>...
                              >[color=green]
                              >>it's a one time emailing to a known group of 1000 people.
                              >>The email addresses are curently in Excel.[/color]
                              >
                              >
                              > Then why bother with PHP at all? Copy the Excel column
                              > of e-mail addresses to Clipboard, paste it into any text
                              > editor that can find end-of-line characters (incidentally,
                              > Word will do), replace end-of-line characters with ', '
                              > (comma plus space), copy to Clipboard again, and paste into
                              > the "Bcc: " field of your regular e-mail software...
                              >
                              > Cheers,
                              > NC[/color]

                              And that, my freinds, deserves the "solution of the week" award ;)

                              he he he...


                              Comment

                              Working...