I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses

Author Message
Shortyspike

  • Total Posts : 6
  • Scores: 0
  • Reward points : 0
  • Joined: 2/7/2012
  • Status: offline
I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Tuesday, February 07, 2012 10:54 AM (permalink)
0
These are form submissions from last year, all people who have liked our company on Facebook. We NEED these emails and have been trying to sue a brutal x-coworker who refused to show us the true location of these emails. So I need to develop a script that can pull either the email field from the emails themselves, OR find a way to import outlook emails into contacts. If anyone could point me in the right direction of scripting or KNOWS OF ONE IN EXISTENCE, that will save me some time. My company barely wants to pay me to write a script, ONLY WILL because they really want these emails and have for a year now.
 
#1
    59cobalt

    • Total Posts : 973
    • Scores: 91
    • Reward points : 0
    • Joined: 7/17/2011
    • Status: offline
    Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 12:34 AM (permalink)
    0
    What kind of "inbox" are you talking about? Is this an Exchange mailbox? IMAP? POP3? Notes? Some webmailer? If you want help you need to give us something to work with.
     
    #2
      Shortyspike

      • Total Posts : 6
      • Scores: 0
      • Reward points : 0
      • Joined: 2/7/2012
      • Status: offline
      Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 4:44 AM (permalink)
      0
      We host our own emails on our webserver. The emails are stored there, and like I said above find a way to export the OUTLOOK emails into contacts of the "From" field. Whichever would be easiest to script either connecting to the webserver or outlook.
       
      #3
        59cobalt

        • Total Posts : 973
        • Scores: 91
        • Reward points : 0
        • Joined: 7/17/2011
        • Status: offline
        Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 6:54 AM (permalink)
        0
        There are no "Outlook" e-mails. There are just e-mails. Let me rephrase my question: are the e-mails in question stored locally (e.g. in a PST file), or are they stored on the server? If they are stored on the server: what kind of mail server software are you using? Exchange? An IMAP server like Cyrus or Dovecot? Something entirely different?
         
        #4
          Shortyspike

          • Total Posts : 6
          • Scores: 0
          • Reward points : 0
          • Joined: 2/7/2012
          • Status: offline
          Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 7:13 AM (permalink)
          0
          It is an IMAP server with a cPanel back end entry. We are hosted through "Host Gator"
           
          #5
            Shortyspike

            • Total Posts : 6
            • Scores: 0
            • Reward points : 0
            • Joined: 2/7/2012
            • Status: offline
            Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 7:20 AM (permalink)
            0
            I understand there are no "outlook" emails. I was simply asking would it be easier to write a script that could work WITH outlook. OR would it be easier to write one for the SERVER where the emails are ORIGINALLY, but ALSO stored.
             
            #6
              59cobalt

              • Total Posts : 973
              • Scores: 91
              • Reward points : 0
              • Joined: 7/17/2011
              • Status: offline
              Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 8:05 AM (permalink)
              0
              Since the mails are stored on an IMAP server, i'd say it's easier to get them from there, provided you have shell access to the server. cPanel seems to use Courier as its IMAP server component, which stores mails in Maildir format. Thus you can probably use a simple Perl script (or even grep/sed/awk) to extract the From: header from the e-mail files.
               
              #7
                Shortyspike

                • Total Posts : 6
                • Scores: 0
                • Reward points : 0
                • Joined: 2/7/2012
                • Status: offline
                Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 8:21 AM (permalink)
                0
                Yeah I'll take a look around at the scripts and hopefully get this done by tomorrow! Thanks for the help.
                 
                #8
                  59cobalt

                  • Total Posts : 973
                  • Scores: 91
                  • Reward points : 0
                  • Joined: 7/17/2011
                  • Status: offline
                  Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 8:52 AM (permalink)
                  0
                  You're welcome. Feel free to ask if you need help with the Perl (or shell) script.
                   
                  #9
                    ebgreen

                    • Total Posts : 8227
                    • Scores: 98
                    • Reward points : 0
                    • Joined: 7/12/2005
                    • Status: offline
                    Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses Wednesday, February 08, 2012 8:56 AM (permalink)
                    0
                    Or doing it in Powershell
                    "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
                    Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
                    http://www.visualbasicscript.com/m_47117/tm.htm
                     
                    #10

                      Online Bookmarks Sharing: Share/Bookmark

                      Jump to:

                      Current active users

                      There are 0 members and 1 guests.

                      Icon Legend and Permission

                      • New Messages
                      • No New Messages
                      • Hot Topic w/ New Messages
                      • Hot Topic w/o New Messages
                      • Locked w/ New Messages
                      • Locked w/o New Messages
                      • Read Message
                      • Post New Thread
                      • Reply to message
                      • Post New Poll
                      • Submit Vote
                      • Post reward post
                      • Delete my own posts
                      • Delete my own threads
                      • Rate post

                      2000-2012 ASPPlayground.NET Forum Version 3.9