Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a label that sorts all my email marketing from one company. I want to export the search results so I can grab the subject lines. There are about 350 messages, and I wanted to research the subject lines. Any ideas?

share|improve this question
up vote 0 down vote accepted

You can use MsgExtract to export only the subject lines or any other email field to excel or to a text file.

After you label the search in gmail, you only need to select the same label in MailExporter and then select the email parts that you want the export:

enter image description here

You can find further information about MsgExtract exporting features here:

http://www.maildev.com/msgextract/

(Disclaimer, I am the author of Msgextract)

share|improve this answer
    
That is EXACTLY what I was looking for @jponce thanks. I will try it out :) – gabearnold Nov 10 '12 at 15:44
    
Mac OS support? – Alex Cook Jan 16 '13 at 20:17

You can try How to export Email from Gmail This is exactly same what you are searching for.

share|improve this answer
    
This is BRILLIANT! Perfect for my need. – Vijay Jun 13 '13 at 6:32
    
Downvote because this solution cost money Hari is the owner, funbutlearn.com/p/search-result.html?q=Hari – cevaris Apr 18 at 17:55

One way to do this is to extract messages to text files by using an IMAP mail client and then using a regular expression to extract subject lines from these text files.

I tried this with Thunderbird.

By default, Thunderbird exports messages by creating one text file per message. Thunderbird names files according to this format: "{subject} - {sender} - {date}.eml". So I already had subjects in file names. Then I just used terminal and redirected ls (use dir, if using Windows) output to a separate text file:

ls -1 > mymessages.txt

In Windows you'd do this:

dir /B > mymessages.txt

If you want to get rid of the sender and date part, you can use your favorite regex supporting text editor (like Notepad++ or vi) and find

^(.*) - .* - .*.eml

in mymessages.txt, replacing it with $1 or \1 (depending on your editor)

share|improve this answer
    
I may try this - but I would have to download 51,000+ message first. I'm not sure if that's a good plan... – gabearnold Nov 5 '12 at 18:21

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .