How to aggregate emails into one text file
-
How can I aggregate the text of multiple received emails into one text file? OK, my real objective here is to have appointments from my work Groupwise 6.5 calendar show up on my Google calendar. I don't have a pda and there is no way to batch export Groupwise calendar information, according to my IT department & my own searching. What I can do is set up a rule to forward each appointment from my Groupwise calendar to an external email account (my IT department has no problem with that; indeed, even suggested it). The forwarded emails show up as text attachments with the calendar information in a fairly regular format. If I had all of those emails combined into one file, I could periodically parse it into a csv format acceptable to Google calendar and import it. This would be, as they say, good enough. But the part I'm stumped at is how to reach into my email box and combine the text of these email attachments into one file. Any suggestions? I feel like this should be simple, but can't quite figure out how to get started. Suggestions on the broader calendar problem are also welcome. I'm using Windows XP on both work and home computers.
-
Answer:
Any mail client that uses the MBOX file format should work for this, I think. I use Thunderbird on XP for my mail and it stores e-mail as an .mbox file. All e-mails that are in the same folder (e.g., the inbox) are stored as is one long text file divided by their message headers. Attachments are all rendered as text, so if they .txt files will show up inline in the .mbox file with a short header before the attachment. By default, the file is in C:\Documents and Settings\[accountname]\Application Data\Thunderbird\Profiles\[profilename]\Mail Thunderbird in XP doesn't add the .mbox extension to file but if you'll be able to open it with any text editor.
yarrow at Ask.Metafilter.Com Visit the source
Other answers
That does sound easy. I use Thunderbird at home so will try this this evening. Thanks!
yarrow
Found it! At first I was looking at the .msf file and was mighty confused, but then I found the .mbox file (looks extensionless). Thank you!
yarrow
Sounds like you're good, but just as another data point, I use gmail to read all my mail that goes to the Groupwise server at work using POP. It picks up the appointments, too, and gmail automagically recognizes them as calendar items and gives me a little "add to google calendar" link with each appointment. I don't think you could set it up to only pull appointments, but if you can find some other way to deal with/ignore/delete non-appointment emails in gmail, you'd never have to mess with any importing.
donnagirl
Yeah, when I forward the appointments to gmail, once in a while it'll recognize as an appointment and let me autoadd, but mostly it doesn't - maybe b/c the appointment details are in an attachment. I'll investigate the POP approach.
yarrow
Related Q & A:
- How to use hadoop for text file?Best solution by Stack Overflow
- How to delete row from text file?Best solution by Stack Overflow
- How to extract information from text file in Python?Best solution by Stack Overflow
- How to forward emails from one account to the other?Best solution by Yahoo! Answers
- How to direct emails from one account to another?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.