Bruce, I ran quick test exporting to Excel and it does a great job and you also have the option of mapping fields as needed. The body does get truncated but It picked up several blocks not t just the first one. I have not checked to see if there is a setting that increases the size. I noticed that there is an option of exporting the data to an Axxxss database; that might be the better option since you can SConnect/SAttach from R:Base and just pick and choose what you want.
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: Friday, August 14, 2015 10:52 AM To: [email protected] 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
