Jason: Thank you. You are right: the whole thing shows up in Notepad.exe.
Issue there is that all field distinctions are lost. Excel shows the body text only if the line #1 has text. Lines > #1 remain invisible if line #2 is blank. Reviewing a utility "MessageExtract" from Encryptomatic.com. Mixed experience so far. Thank you Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kramer, Jason J Sent: Friday, August 14, 2015 9:17 AM To: [email protected] Subject: [RBASE-L] - RE: Importing emails from Outlook 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
