Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.