Exporting email subjects to Excel
July 10, 2008 1:07 PM Subscribe
How can I export a bunch of email subjects to Excel?
I have a few hundred emails that all have the same type of subject: Last name, First name, ID code. I'd really like to export these subjects into an excel file so I can sort by name and compare them to another excel file that I have. Currently, I'm comparing the other excel file I have on paper with the list of emails I have on the screen. This will get old soon. Any ideas? (the email I'm using is Thunderbird)
I have a few hundred emails that all have the same type of subject: Last name, First name, ID code. I'd really like to export these subjects into an excel file so I can sort by name and compare them to another excel file that I have. Currently, I'm comparing the other excel file I have on paper with the list of emails I have on the screen. This will get old soon. Any ideas? (the email I'm using is Thunderbird)
It's been a while since I've used Thunderbird, but IIRC, you can export the address book as Comma Separated Value, which always worked well for me in Excel.
posted by sjuhawk31 at 1:26 PM on July 10, 2008
posted by sjuhawk31 at 1:26 PM on July 10, 2008
Use SnagIt:
capture profile: Scrolling Window
mode:Text.
This will copy the header lines as they appear in your inbox. Then just past into Excel. If you're using Outlook, temporarily hide all fields except Subject, otherwise you'll need to do some minor column cleanup when you paste.
posted by for_serious at 2:46 PM on July 10, 2008
capture profile: Scrolling Window
mode:Text.
This will copy the header lines as they appear in your inbox. Then just past into Excel. If you're using Outlook, temporarily hide all fields except Subject, otherwise you'll need to do some minor column cleanup when you paste.
posted by for_serious at 2:46 PM on July 10, 2008
This thread is closed to new comments.
posted by ochenk at 1:25 PM on July 10, 2008