Outlook .MSG FileOpen FileRead - Getting strange symbols

[souldjer777]

Howdy Everyone!

I've been scouring the forum for something that works... and no dice yet... hoping to stop the frustration - hope someone in the forum knows what to do.

Basically, I've saved .msg files out of MS Outlook and want to scan each on for email addresses but all I get with fileopen and fileread are symbols... ran through every iteration.

I've seen people do some soft of binary extract and binarytostring but I haven't gotten that to work either... not sure what's going on.

Neither of these have worked for me... yes I know they are old and FileOpen has changed... but like I said I tried everything that I know of.

Please help
 

$sFile = "C:\temp\messages\Test.msg"
$hFile = FileOpen($sFile, 16) ; 16 = binary
$binData = FileRead($hFile, 1024) ; read first 1KB
FileClose($hFile)
ConsoleWrite("Debug: First 1KB = " & $binData & @LF)

or...

$sFile = "C:\temp\messages\Test.msg"
$hFile = FileOpen($sFile, 16)
$binData = FileRead($hFile, 20480)
FileClose($hFile)
$startdef=StringTrimLeft(Binary('thetextIamlookingfor'), 20)
$enddef=StringTrimLeft(Binary('moretextIamlookingfor'), 20)
$binData=StringTrimLeft($binData, StringInStr($binData, $startdef)+StringLen($startdef)-1)
$binData=StringLeft($binData, StringInStr($binData, $enddef)-1)
ConsoleWrite(BinaryToString('0x'&$binData) & @LF)

Thanks!

[water]

If you still have Outlook installed you could use my OutlookEX UDF to open the msg files and extract the needed data.

[souldjer777]

Thank you water - yes... I saw your posts ealier. No way to FileOpen / FileRead?

[mLipok]

Is it normal EML ?

[water]

I do not know the data structure of a saved msg.
I know that with the OutlookEX UDF it should be easy to extract the information you need.

[souldjer777]

mLipok - Not sure what you mean by that... I believe it is... I just copied it out of Outlook and into a temporary directory. Sorry, but how would I determine that?

Edited December 31, 2015 by souldjer777

[ViciousXUSMC]

Kind of the same issue I had trying to open an odd file type a while back, do not think I ever figured out how to quite do it even after trying ever file open option and all the binary/string conversions.

For this in particular I was able to use Notepad++ and while the majority of it is just "gibberish" there are email address inside that I could easily search via RegEx

\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b

Notepad++ is free if Outlook is not an option. 

[mLipok]

Open this file as text in notepad or any other editor.

If you see something like this

Return-Path: <some@email.pl>
X-Original-To: my@email.com
Received: from localhost (unknown [127.0.0.1])
    by my.email.server.com (Postfix) with ESMTP id E13951926130
    for <my@email.com>; Sat, 19 Dec 2015 18:23:33 +0100 (CET)
X-Virus-Scanned: amavisd-new at my.email.server.com
X-Spam-Flag: NO
X-Spam-Score: -3.307
X-Spam-Level: 
X-Spam-Status: No, score=-3.307 tagged_above=-100 required=7

I suppose this is EML format.

 

[InunoTaishou]

I think all, if not all then most, Microsoft Office programs save their files as just .zip files renamed to the extension of the program.

What I mean is, if you create a .docx, .xmls, or .pptx file, add some information to it, then rename it to .zip you will find some archived folders and files. There was a post on here where someone did a StringRegExpReplace (I think it was this) to extract the data. Alternatively you could just unzip it into the temp direction, find the file with the email address, and then clean up your resources. I don't have outlook so I can't test it myself.

This was the post.

[souldjer777]

These are kick a** ideas, I'll give them a shot! Thanks! 

[souldjer777]

Holy crap were you right about the zipping... just did right click 7zip > extract - can see all the info.

So out of the 75 files or so... WOW... I can get everything I need lol - sadly that worked kinda 

Edited January 1, 2016 by souldjer777

[InunoTaishou]

Holy crap were you right about the zipping... just did right click 7zip > extract - can see all the info.

So out of the 75 files or so... WOW... I can get everything I need lol - sadly that worked kinda 

Most of it's just xml formatting and settings. In a word .docx the actual document text is stored in ..\word\document.xml

Just gotta find the right xml file with the info you need. GL on your hunt!