Just the facts: list of emails, but no body contents, please.
July 24, 2014 7:07 PM Subscribe
I need to pull out just the Sender, Subject, Date, Time info from an email archive. Any way to do this easily? Details inside.
posted by Gotanda to Computers & Internet (3 answers total) 1 user marked this as a favorite
I have a local copy of a .mbox archive for one user on my Mac that I've opened in Mail. These messages are from November 2013 to January 2014. The mail server logs have long since been deleted. The email user is deceased. The Labor Standards Office is inquiring about the amount of work this person was doing and I would like to cooperate. Documenting these emails would be helpful, but I do not want to just give a government office a dump of the full emails from an NPO officer. I don't think there is anything sensitive in there, but it establishes a bad precedent.
I would like (and a lawyer agrees this is a good idea) to make a report like what I see when I open the folder in Mail: Sender, Subject, Date, Time. Is there some way to get only that out as just text? If I highlight all of the messages and copy and paste into a text editor, it copies the entire message contents. I imagine if I had super regex fu, this would be a piece of cake, but I don't. How can I copy, export, or otherwise get just the text I want (excluding the email body) so I can drop it in Excel and make a report? I really don't want to wade through 700+ emails to copy this stuff out manually. Thank you hivemind!