Hi, is it an idea to have readers read through a .msg (MicroSoft Outlook) file? Say, there is a mail file with an .xls attachment in it. We could select the .msg file for the Excel reader and it reads all .xls attachments without having to open the msg, save all attachments to disk and than create the Excel reader to read the stored attachments? I have a bunch (like 365 or so) e-mail reports from webfleet that all contain 1 xls file with travelreports that I want to analyze.
Open
Readers read through Outlook .msg file like zip
I have been using MailtoX and converting .msg to HTML then using HTML Table reader. Hope we can read .msg one day. Hope this helps
+1- Contributor
Hi,
I had similar issues where i had to extract csv file from more than 200 .msg file. Tried different things, but work around for it was:
1. Unzipped all the .msg file with 7zip extractor
2. Read path (File Path reader) of all the extracted message folder with Path Filter = *.0_37010102, to avoid reading unwanted files.
3. Found the attachment as csv (for my case the location of the csv was here;
"C:\\ExtractedFolder\\msg folder name\\__attach_version1.0_#00000000\\__substg1.0_37010102"
5. File copy as writer to write these files with ".csv" extension
Would have been lot easier if we have reader that reads it as archive file for .msg extensions.
Hope this helps, a workaround until we have proper .msg reader!!
+7- Contributor
nepalikiwi wrote:
Hi,
I had similar issues where i had to extract csv file from more than 200 .msg file. Tried different things, but work around for it was:
1. Unzipped all the .msg file with 7zip extractor
2. Read path (File Path reader) of all the extracted message folder with Path Filter = *.0_37010102, to avoid reading unwanted files.
3. Found the attachment as csv (for my case the location of the csv was here;
"C:\\ExtractedFolder\\msg folder name\\__attach_version1.0_#00000000\\__substg1.0_37010102"
5. File copy as writer to write these files with ".csv" extension
Would have been lot easier if we have reader that reads it as archive file for .msg extensions.
Hope this helps, a workaround until we have proper .msg reader!!
Great ! Thank you
In my Case, I have multiple emails with 1 attached JPG that I need to keep in a folder. I can find the name of the attached file into the __substg1.0_803C101F-00000000 file !
A .msg Reader would be a very good idea !
Thanks !
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.