[kdepim-users] Exporting Kmail messages to Spreadsheet?
peter777 at users.sourceforge.net
Sat Aug 15 10:10:46 BST 2009
On Friday 14 August 2009 22:41:13 you wrote:
> ----- Original Message ----
> From: Peter <peter777 at users.sourceforge.net>
> To: kdepim-users at kde.org
> Sent: Friday, August 14, 2009 8:24:40 AM
> Subject: Re: [kdepim-users] Exporting Kmail messages to Spreadsheet?
> Spreadsheets need delimeters, and you could use CRLF (hex 0A hex 20) as the
> delimeter, which will work fine for all the email headers, however in the
> body of the email, there would be a CRLF on each line I guess, unless
> wordwrap was turned off for the body part, somehow ??
> On Friday 14 August 2009 21:57:38 r bartlett wrote:
> > Is there any way to (either within Kmail itself or perhaps by using a
> > command line?) get certain fields (To: From: Sent date, Subject, Body
> > of Message, etc.) to export to a spreadsheet?
> > I don't want to do this for each and every message -- only for certain
> > ones I've identified using the Search feature. Currently I'm selecting
> > each part of the message and pasting. Is there an easier way?
> > Many thanks!
> So, Peter, assuming I didn't mind passing on the body of the message
> (that's really not too difficult to cut and paste on my own if I have to),
> how would I use this CRLF in order to get my file imported.
> Would the process be:
> 1. Open OpenOffice Spreadsheet.
Save the file first, then open Openoffice Spreadsheet.
> 2. Open the Import dialog
The file I just saved only had CR (carriage return), which is fair enough,as
this is a Linux box. The CR is a special character that looks like this
so, in the import dialog, uncheck 'Tab', check 'other' then past the special
> 3. Point it to a specific file? (How do I locate a specific Kmail file,
> btw? I assume it's buried in a maildir or mbox or something, no?) 4.
Hmm, it sort of worked for me, but it came out as rows, no doubt you want each
line to be a column I think.
KDE PIM users mailing list
kdepim-users at kde.org
More information about the kdepim-users