Dear Bruce,
Check the resulting CSV file in a program other than Excel, such as
Notepad, Notepad++, or Wordpad. The entire body of the message, even for
lengthy messages will be there. You can see the whole body in Excel if you
resize the body cell.
I have not found a way to only export certain messages. As you found,
all messages in a folder are exported. I tried using a Search Folder, but
those can't be selected for exporting.
Thanks,
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea
Sent: Friday, August 14, 2015 11:52 AM
To: Kramer, Jason J
Subject: [RBASE-L] - RE: Importing emails from Outlook
Javier:
Thank you. I had not tried that, so just ran a test export to .CSV.
Export works on ALL messages in a folder at once. No individual message export
option.
Does an excellent job of parsing subject and address information.
Takes the first block of body text ONLY. If that first line is 'Javier:',
that's all you get. Otherwise, only the first paragraph. All else ignored.
As this is a forensic job, I'll see if there's a utility out there and report
what I find.
Thanks again,
Bruce
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia
Sent: Friday, August 14, 2015 8:38 AM
To: [email protected]
Subject: [RBASE-L] - RE: Importing emails from Outlook
Bruce,
Have you tried exporting the data you need to and excel file and the importing
it into R:Base from the spreadsheet?
In Outlook 2010-2013 go to File>>Options>>Advanced and you will see a section
called Export that allows you to export your data to several formats.
Yes, it is a two-step process but it could be a workable temporary workaround.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A.
Chitiea
Sent: Thursday, August 13, 2015 4:32 PM
To: [email protected]
Subject: [RBASE-L] - Importing emails from Outlook
I need to import several hundred emails for analysis.
Mapping:
Date, time, from: , to: , cc: , bcc: , subject line , message body
... to an appropriate data structure.
Does anyone have experience with this who can talk it out with me?
Anyone have a code set for the job?
Bruce
SafeSectors, Inc.
909.238.9012 mobile
