Reading email body from the .eml file without any extra symbols and headers - (Moved)

[VipinNaudiyal]

Dear All,

I need to read the body of an .eml file including its content and generate a .CSV/Excel/Word our of it.

Can any one suggest, how can we do it.

@water- I tried to explore your UDF, but got confused where to start from..

What I have : 50 .eml files.

Expected out put -   single excel/csv/word file (including the chain email)

Please help

Vipin

Edited February 22, 2024 by VipinNaudiyal

[argumentum]

have you try opening an .eml with notepad ?

[VipinNaudiyal]

yes, it is not what i needed because it brings lots of header information with it.

[argumentum]

well, if you can read that, you'll see that is all clear text and what is not, is base64.
The request of "Expected out put -   single excel/csv/word" is not quite clear. Why Word, and if so, then the chain on a CSV to open in Excel ?. But you can thinker that on your own. Unless you'd like someone to give you the custom software you envision ?
I think you should use thunderbird. Give it a try. It may be all you need.

[VipinNaudiyal]

@argumentum- Thanks for spending time on the forum.

Please note - My requirement is to work on any emails body content (available to me in .eml format only)  for my work that can be in csv format as well.

The important point is, it should be capturing the chain of conversation as well e.g below.

Mail 5: 13:15 PM, 22 Feb 2024

*********

------------------------------------------

Mail 4:12:27 PM, 21 Feb 2024

*********

------------------------------------------

Mail 3: 12:25 PM, 21 Feb 2024

*********

-------------------------------------------

Mail 2: 10:40 AM, 21 Feb 2024

From : vipinnaudiyal88@yahoo.co.in

To : Ramesh_@gmail.com

Hi Ramesh,

I am good, you tell, How it is going?

Regards

Vipin

-------------------------------------------------------

Mail 1: 08:30 AM, 20 Feb 2024

From : Ramesh_@gmail.com

To : vipinnaudiyal88@yahoo.co.in

Hi Vipin,

How are you, Hope you are doing Good

Regards

Ramesh

 

hope it is now clear

 

[Melba23]

Moved to the appropriate forum.

Moderation Team

[water]

5 hours ago, VipinNaudiyal said:

@water- I tried to explore your UDF, but got confused where to start from..

Did you try function _OLT_EML_Get that comes with the OutlookTools UDF?

[VipinNaudiyal]

I don't find this file

[water]

Seems the latest version of the OutlookTools UDF never made it to the forum.

Here is the function you are looking for

expandcollapse popup

; #FUNCTION# ====================================================================================================================
; Name...........: _OLT_EML_Get
; Description ...: Returns the content of an EML file as a serialized stream within a single ADO Stream object.
; Syntax.........: _OLT_EML_Get($sEMLPath[, $sProperty = Default])
; Parameters ....: $sEMLPath - Path to an EML mail file e.g. "C:\Local\Test.EML"
;                  $sPropery - [optional] Property to return. See Remarks (default = keyword Default)
; Return values .: Success - Sets global variable $__g_oIMessage to the IMessage interface object and [optional] returns the specified property
;                  Failure - Returns 0 and sets @error:
;                  |1  - Could not create the IMessage object. @extended is set to the COM error code
;                  |2  - Could not create the ADO stream object. @extended is set to the COM error code
;                  |3  - Error accessing property $sProperty. Maybe the specified property does not exist?
; Author ........: maniootek, mLipok (in alph. order). See: https://www.autoitscript.com/forum/topic/207419-eml-file-with-body-base64-encoded-decoder
; Modified ......: water
; Remarks .......: The function always sets the global variable $__g_oIMessage to IMessage interface object.
;                  So you can access all properties after the function has been called.
;                  This is true even when you call the function using $sProperty to return the value of a single property.
;                  A list of available properties can be found here:
;                  iMessage: https://docs.microsoft.com/en-us/previous-versions/office/developer/exchange-server-2007/aa579703(v=exchg.80)
;+
;                  Further information:
;                  ADO: https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/stream-object-ado?view=sql-server-ver15
; Related .......: _OL_ItemSaveAs
; Link ..........:
; Example .......:
; ===============================================================================================================================
Func _OLT_EML_Get($sEMLPath, $sProperty = Default)
    Local Const $sCLASSID_IMessage = "{CD000001-8B95-11D1-82DB-00C04FB1625D}" ; CLSID of the IMessage interface
    Local $oADOStream
    If Not IsDeclared("__g_oIMessage") Then
        Global Static $__g_oIMessage = ObjCreate($sCLASSID_IMessage)
        If @error Then Return SetError(1, @error, 0)
    EndIf
    $oADOStream = $__g_oIMessage.GetStream() ; Return the message in serialized (wire-transport) format in a ADO stream object
    If @error Then Return SetError(2, @error, 0)
    $oADOStream.LoadFromFile($sEMLPath)
    If @error Then Return SetError(3, @error, 0)
    $oADOStream.Flush()
    If $sProperty <> Default Then
        $sResult = Execute("$__g_oIMessage." & $sProperty)
        If @error Then Return SetError(3, @error, 0)
        Return $sResult
    EndIf
EndFunc   ;==>_OLT_EML_Get

 

[VipinNaudiyal]

Thanks @water , If I call the function like this

_OLT_EML_Get(@ScriptDir&"\2023-05-18T18_58_01Z.eml")

How will I be receiving the data.

I also heard from someone that eml data cannot be extracted directly as it has some specific format.

Can you guide what exactly i need to extract the context

[water]

In the function header you'll find the needed information
Use

$sTextBody = _OLT_EML_Get(@ScriptDir & "\2023-05-18T18_58_01Z.eml", "TextBody")

to get the TextBody of the EML file.

Edited February 22, 2024 by water
Removed the leading quote - was wrong

[VipinNaudiyal]

Thanks a lot @water- Amazing work and to the point help.

🙏

[junkew]

You could read it just as a sequential file. See https://datatracker.ietf.org/doc/html/rfc2822 for eml standard.