Skip to main content
Archived

Readers read through Outlook .msg file like zip

Related products:Integrations
dave_seamless
rylanatsafe
hvukasinovic
cshepard
siennaatsafe
+87
  • dave_seamless
    dave_seamless
  • rylanatsafe
    rylanatsafe
  • hvukasinovic
    hvukasinovic
  • cshepard
    cshepard
  • siennaatsafe
    siennaatsafe
  • fmelizard
    fmelizard
  • david_r
    david_r
  • nielsgerrits
    nielsgerrits
  • ebygomm
    ebygomm
  • redgeographics
    redgeographics
  • takashi
    takashi
  • danilo_fme
    danilo_fme
  • jdh
    jdh
  • erik_jan
    erik_jan
  • warrendev
    warrendev
  • tcrossman
    tcrossman
  • vxn43
    vxn43
  • jkr_wrk
    jkr_wrk
  • j.botterill
    j.botterill
  • tomf
    tomf
  • todd_davis
    todd_davis
  • bruceharold
    bruceharold
  • oliver.morris
    oliver.morris
  • larue
    larue
  • nic_ran
    nic_ran
  • kennyo
    kennyo
  • chriswilson
    chriswilson
  • dms2
    dms2
  • r_huesken
    r_huesken
  • timboberoosky
    timboberoosky
  • bibold
  • tim_wood
    tim_wood
  • revesz
    revesz
  • gerhard
  • esko
    esko
  • noobud
    noobud
  • jackieu
  • aalppa
  • richardsr
    richardsr
  • jjf
    jjf
  • jnotter
    jnotter
  • kahlen
    kahlen
  • osmanbeg1980
    osmanbeg1980
  • carstenotto
    carstenotto
  • redlands_gis
  • ashish_man
    ashish_man
  • jjuker
  • mikev
    mikev
  • cwarren
    cwarren
  • simonl
    simonl
  • danielloov
  • laimonasliskaus
  • sam.mcdonald
    sam.mcdonald
  • geoinfomartin
  • alexbiz
    alexbiz
  • margotdh
    margotdh
  • aabdellnasser
    aabdellnasser
  • ecthelion
    ecthelion
  • kd
  • mmccart
    mmccart
  • johnt
    johnt
  • evieatsafe
    evieatsafe
  • becchr
    becchr
  • cfvonner
    cfvonner
  • ngstoke
    ngstoke
  • ewb_fme
    ewb_fme
  • xilef
    xilef
  • anari
    anari
  • gboquin
    gboquin
  • taojunabc
    taojunabc
  • hannahwh05
    hannahwh05
  • tomcolley
    tomcolley
  • geoportalcartog
    geoportalcartog
  • geoal
    geoal
  • candacel
    candacel
  • ryan
    ryan
  • reedwhit
    reedwhit
  • wolters
    wolters
  • u12runm
    u12runm
  • richardt
    richardt
  • keithhastings
    keithhastings
  • janrykr
    janrykr
  • denniswilhelm
    denniswilhelm
  • soeren
    soeren
  • glevesque
  • clarkhannon
  • jessicazimmer
  • janr
  • samuelvaldez
  • evanlavine
  • xglazier
  • laurawatsafe
    laurawatsafe

helmoet

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.

4 replies

  • May 14, 2018

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


nepalikiwi
Contributor
Forum|alt.badge.img+1
  • Contributor
  • September 6, 2018

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!!


mlupien
Contributor
Forum|alt.badge.img+7
  • Contributor
  • March 24, 2025
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 ​@nepalikiwi for the hint !

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 !


LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • April 5, 2025
OpenArchived

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings