Extracting HTML tables with a specific format from Outlook to Excel with VBA

M

MrHelpcel

New Member
Joined
Jan 21, 2022
Messages
32
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2013
  6. 2011
  7. 2010
  8. 2007
  9. 2003 or older
Platform
  1. Windows
Hello all!

I have a question regarding extraction of HTML tables of a specific format (not your standard rows and columns table) from outlook, and to put the corresponding information in row format on an excel file.

Previously, with the help of Domenic on this forum (which I CANNOT THANK ENOUGH for all the help he provided me with) I managed to extract all the conventional HTML tables from a specific outlook subfolder. This resulted in a huge file with all the data recorded in rows per table (which was exactly what I wanted). Please see the link for reference: Outlook/VBA - Extracting tables from all emails in a specific folder

However, there are some HTML tables (sort of) that still haven't been successfully extracted. The reason I add the "sort of" part, is due to the nature of these tables. In the source, they are categorized as tables, but they are not your standard row and column tables. I will provide a screenshot of it (sorry for all the censoring, I don't want to get in trouble with the company!):

HKgrSd0l.jpg



Is there a way to obtain information from this table to into excel?


Would it be possible to write some VBA code to extract the information from the little "Enter text here" fields? I already have some code that helped me in retrieving the data from the previous tables (the standard row and column tables), perhaps it could be modified to grab this data instead?

VBA Code: 
Option Explicit

Sub demo()

    Dim oApp As Outlook.Application
    Dim oMapi As Outlook.MAPIFolder
    Dim oMail As Outlook.MailItem
    Dim oItem As Variant
    Dim oHTML As MSHTML.HTMLDocument
    Dim oTable As MSHTML.HTMLTable
    Dim oTables As MSHTML.IHTMLElementCollection
    Dim nextRow As Long
    Dim x As Long
    Dim y As Long
  
    On Error Resume Next
    Set oApp = GetObject(, "Outlook.Application")
    If oApp Is Nothing Then
        Set oApp = CreateObject("Outlook.Application")
        If oApp Is Nothing Then
            MsgBox "Unable to start Outlook!", vbExclamation, "Outlook"
            Exit Sub
        End If
    End If
    On Error GoTo 0
  
    Set oMapi = oApp.GetNamespace("MAPI").Folders("folder1").Folders("folder2").Folders("folder3").Folders("folder4")
  
    nextRow = Cells(Rows.Count, "A").End(xlUp).Row + 1
  
    For Each oItem In oMapi.Items
        If TypeName(oItem) = "MailItem" Then
            Set oMail = oItem
            Set oHTML = New MSHTML.HTMLDocument
            With oHTML
                .Body.innerHTML = oMail.HTMLBody
                Set oTables = .getElementsByTagName("table")
            End With
            For Each oTable In oTables
                For x = 0 To oTable.Rows.Length - 1
                    For y = 0 To oTable.Rows(x).Cells.Length - 1
                        If y = 1 Then
                            Cells(nextRow, "A").Value = oMail.ReceivedTime
                            Cells(nextRow, "B").Value = oMail.Subject
                            Cells(nextRow, "C").Offset(y - 1, x).Value = oTable.Rows(x).Cells(y).innerText
                        End If
                    Next y
                Next x
                nextRow = nextRow + 1
            Next oTable
            Set oHTML = Nothing
            Set oMail = Nothing
        End If
    Next oItem
  
    Set oApp = Nothing
    Set oMapi = Nothing
    Set oMail = Nothing
    Set oHTML = Nothing
    Set oTable = Nothing
    Set oTables = Nothing
  
End Sub

I would be very thankful for any help that you guys can provide!
 
Sort by date Sort by votes
Usually they all follow the same structure. The information it extracted into excel is basically a table from the case we went over in another thread: It's extracting the final table we receive, but not the initial acknowledgement table, which has a different structure. Aside from that, the extracted email is structured like the rest of the emails in the target email folder, but it seems to only extract the first table in the email thread, as opposed to the table at the beginning of the thread, which happens to be the one I am looking for (and has a different structure, as seen in the screenshot and html code I posted above).
 
Upvote 0

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Were any of the emails processed? Was that particular email the only with the error?
 
Upvote 0
Only that email thread was processed. Then after it tried looping over a third time the runtime error popped up. I could provide you the code and better snapshots, but given the potential sensitivity of the information, it would be through direct messaging, and I dont know if you'd prefer that, given that answers are better publicly shared
 
Upvote 0
So, if I understood correctly, with the first two loops, you didn't get an errors. But with the third loop, you did. Is this right? If so, it means that the format of the third email differs from that of the first two. It also means that other emails could potentially have differing formats. If so, it would be somewhat difficult to code.
 
Upvote 0
Thats correct. It picked the first two tables in a thread with multiple emails, but the one I was looking for specifically wasnt picked up. AKA it picked up the other ones, but not the intended one. Im assuming it looked at the email thread and started picking up tables, starting from the latest one first, instead of the "oldest" one in the thread first, which has a different structure than the other ones
Domenic said:
So, if I understood correctly, with the first two loops, you didn't get an errors. But with the third loop, you did. Is this right? If so, it means that the format of the third email differs from that of the first two. It also means that other emails could potentially have differing formats. If so, it would be somewhat difficult to code.
Click to expand...
 
Upvote 0
Having said that though, the tables are separated into two categories: the acknowledgement table follows a certain structure (as seen in the initial pic of it), and the other table follows a 2-column, 18-row format, with headers on the first column, and data on the second column. It is picking up the latter, but throwing an error when it finally loops to the former.
 
Upvote 0
Okay, I think we need to start over.

Post the entire HTML source code for a sample email.

Don't delete any code from the source code.

Replace any confidential information with fake information.

Based on that sample email, post the desired result.
 
Upvote 0
Domenic said:
Okay, I think we need to start over.

Post the entire HTML source code for a sample email.

Don't delete any code from the source code.

Replace any confidential information with fake information.

Based on that sample email, post the desired result.
Click to expand...

Hello, attached is the code in an HTML snippet:

HTML: 
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="Generator" content="Microsoft Word 15 (filtered medium)">
    <style>
        <!--
        /* Font Definitions */
        @font-face {
            font-family: "Cambria Math";
            panose-1: 2 4 5 3 5 4 6 3 2 4;
        }

        @font-face {
            font-family: Calibri;
            panose-1: 2 15 5 2 2 2 4 3 2 4;
        }

        /* Style Definitions */
        p.MsoNormal,
        li.MsoNormal,
        div.MsoNormal {
            margin: 0cm;
            font-size: 11.0pt;
            font-family: "Calibri", sans-serif;
        }

        a:link,
        span.MsoHyperlink {
            mso-style-priority: 99;
            color: blue;
            font-style: normal;
            text-decoration: none none;
        }

        span.StileMessaggioDiPostaElettronica22 {
            mso-style-type: personal-reply;
            font-family: "Calibri", sans-serif;
            color: windowtext;
        }

        .MsoChpDefault {
            mso-style-type: export-only;
            font-size: 10.0pt;
        }

        @page WordSection1 {
            size: 612.0pt 792.0pt;
            margin: 70.85pt 2.0cm 2.0cm 2.0cm;
        }

        div.WordSection1 {
            page: WordSection1;
        }
        -->
    </style>
    <!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]-->
    <!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang="IT" link="blue" vlink="purple" style="word-wrap:break-word">
    <div class="WordSection1">
        <p class="MsoNormal"><span lang="EN-US" style="color:#203864;mso-fareast-language:EN-US">lorem ipsum,
                <o:p></o:p>
            </span></p>
        <p class="MsoNormal"><span lang="EN-US" style="color:#203864;mso-fareast-language:EN-US">lorem ipsum:<o:p></o:p>
            </span></p>
        <p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1038"
            style="width:778.8pt;border-collapse:collapse">
            <tbody>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p>
                                </o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203864">Data
                                123</span><span style="color:#203764">
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Data 123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Data 123<o:p>
                                </o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p>
                                </o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
            </tbody>
        </table>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <p class="MsoNormal"><span style="color:#203864;mso-fareast-language:EN-US">Best regards<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#203864;mso-fareast-language:EN-US">Name<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <div>
            <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
                <p class="MsoNormal"><b>From:</b> lorem ipsum <br>
                    <b>Sent:</b> date it was sent<br>
                    <b>To:</b> email@email.com<br>
                    <b>Cc:</b> email@email.com<br>
                    <b>Subject:</b> Subject info<o:p></o:p>
                </p>
            </div>
        </div>
        <p class="MsoNormal">
            <o:p>&nbsp;</o:p>
        </p>
        <p class="MsoNormal"><span lang="EN-US" style="color:#203864;mso-fareast-language:EN-US">lorem ipsum
                <o:p></o:p>
            </span></p>
        <p class="MsoNormal"><span lang="EN-US" style="color:#203864;mso-fareast-language:EN-US">lorem ipsum<o:p></o:p>
            </span></p>
        <p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1038"
            style="width:778.8pt;border-collapse:collapse">
            <tbody>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Hedaer
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p>
                                </o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Data 123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p>
                                </o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Header
                                123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123<o:p></o:p></span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123
                                <o:p></o:p>
                            </span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center">Data <span
                                style="color:#203764">12345
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
                <tr style="height:14.5pt">
                    <td width="378" nowrap=""
                        style="width:283.8pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US"
                                style="color:#203764">Header 123<o:p></o:p></span></p>
                    </td>
                    <td width="660" nowrap=""
                        style="width:495.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:14.5pt">
                        <p class="MsoNormal" align="center" style="text-align:center"><span style="color:#203764">Data
                                123
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
            </tbody>
        </table>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <p class="MsoNormal"><span style="color:#203864;mso-fareast-language:EN-US">Best regards<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#203864;mso-fareast-language:EN-US">Name<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <div>
            <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
                <p class="MsoNormal"><b>Da:</b> Company name &lt;<a
                        href="mailto:email@gmail.com">email@gmail.com</a>&gt;
                    <br>
                    <b>Sent:</b> date it was sent<br>
                    <b>To:</b> <a href="mailto:email@gmail.com">email@gmail.com</a><br>
                    <b>Cc:</b> Name 1 &lt;<a href="mailto:email@gmail.com">email@gmail.com</a>&gt;; Name 2
                    &lt;<a href="mailtoemail@gmail.com">email@gmail.com</a>&gt;; Name 3 &lt;<a
                        href="mailto:email@gmail.com">email@gmail.com</a>&gt;;
                    Name 4 &lt;<a href="mailto:email@gmail.com">email@gmail.com</a>&gt;; Company name &lt;<a
                        href="mailto:email@gmail.com">email@gmail.com</a>&gt;<br>
                    <b>Subject:</b> Subject info<o:p></o:p>
                </p>
            </div>
        </div>
        <p class="MsoNormal">
            <o:p>&nbsp;</o:p>
        </p>
        <p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">lorem ipsum,<o:p></o:p>
            </span></p>
        <p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">lorem ipsum<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">Best Regards<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">Name<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <p class="MsoNormal"><span style="mso-fareast-language:EN-US">
                <o:p>&nbsp;</o:p>
            </span></p>
        <div>
            <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
                <p class="MsoNormal"><b>From:</b> <a href="mailto:email@gmail.com">email@gmail.com</a> &lt;<a
                        href="mailto:email@gmail.com">email@gmail.com</a>&gt;
                    <br>
                    <b>Sent:</b>Date email sent<br>
                    <b>To:</b> Company name <a href="mailto:email@gmail.com">email@gmail.com</a>&gt;<br>
                    <b>Cc:</b> Name &lt;<a href="mailto:email@gmail.com">email@gmail.com</a>&gt;; Name 2
                    &lt;<a href="mailto:email@gmail.com">email@gmail.com</a>&gt;<br>
                    <b>Subject:</b> Subject info<o:p></o:p>
                </p>
            </div>
        </div>
        <p class="MsoNormal">
            <o:p>&nbsp;</o:p>
        </p>
        <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0">
            <tbody>
                <tr>
                    <td style="border:solid #D3212D 1.0pt;background:#FAFFB3;padding:.75pt .75pt .75pt .75pt">
                        <p class="MsoNormal"><strong><span
                                    style="font-family:&quot;Arial&quot;,sans-serif;color:black">Attention:
                                </span></strong><span style="font-family:&quot;Arial&quot;,sans-serif;color:black">lorem
                                ipsum lorem ipsum.<br>
                                <strong><span style="font-family:&quot;Arial&quot;,sans-serif">Warning</span></strong>:
                                lorem ipsum lorem ipsum
                                <o:p></o:p>
                            </span></p>
                    </td>
                </tr>
            </tbody>
        </table>
        <p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">
                <o:p>&nbsp;</o:p>
            </span></p>
        <div>
            <p class="MsoNormal"><span
                    style="font-size:1.0pt;font-family:&quot;Arial&quot;,sans-serif;color:white">--==_</span><span
                    style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">
                    <o:p></o:p>
                </span></p>
            <div id="body_style">
                <p class="MsoNormal"><span
                        style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">
                        <o:p>&nbsp;</o:p>
                    </span></p>
                <div align="center">
                    <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%"
                        style="width:100.0%">
                        <tbody>
                            <tr>
                                <td width="100%" style="width:100.0%;background:white;padding:11.25pt 0cm 7.5pt 0cm">
                                    <div align="center">
                                        <table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0"
                                            width="800" style="width:600.0pt">
                                            <tbody>
                                                <tr>
                                                    <td style="background:white;padding:0cm 0cm 0cm 0cm">
                                                        <p class="MsoNormal"><span
                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">&nbsp;
                                                                <o:p></o:p>
                                                            </span></p>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td width="800" valign="top"
                                                        style="width:600.0pt;border:solid #E5E5E5 1.0pt;background:white;padding:0cm 0cm 0cm 0cm">
                                                        <table class="MsoNormalTable" border="0" cellspacing="0"
                                                            cellpadding="0" align="left" width="800"
                                                            style="width:600.0pt">
                                                            <tbody>
                                                                <tr>
                                                                    <td width="738" valign="top"
                                                                        style="width:553.5pt;padding:18.75pt 22.5pt 15.0pt 22.5pt">
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Dear
                                                                                Company name,<br>
                                                                                <br>
                                                                                lorem ipsum <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">#12345
                                                                                    </span></strong>lorem ipsum
                                                                                additional info.
                                                                                You'll find all relevant details below.
                                                                                lorem ipsum additional info<br>
                                                                                <br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">ID
                                                                                        of place:
                                                                                    </span></strong>Data 123<br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Street
                                                                                        Name: </span></strong>Address
                                                                                info
                                                                                <br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">City:</span></strong>
                                                                                City name<br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Country:</span></strong>
                                                                                Country name
                                                                                <br>
                                                                                <br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Main
                                                                                        Info:</span></strong>
                                                                                More Info
                                                                                <br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Phone
                                                                                        number:</span></strong> /
                                                                                123456789
                                                                                <br>
                                                                                <br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Date
                                                                                    </span></strong>: Info on date<br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Expected
                                                                                        date:</span></strong>
                                                                                Info on date<br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Issue:
                                                                                    </span></strong>Info of issue<o:p>
                                                                                </o:p></span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt">
                                                                            <strong><span
                                                                                    style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">
                                                                                    Header 1:</span></strong><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">
                                                                                <o:p></o:p>
                                                                            </span>
                                                                        </p>
                                                                        <table class="MsoNormalTable" border="0"
                                                                            cellspacing="0" cellpadding="0" width="739"
                                                                            style="width:554.25pt;border-collapse:collapse">
                                                                            <tbody>
                                                                                <tr>
                                                                                    <td width="715"
                                                                                        style="width:536.25pt;border:inset 1.0pt;padding:5.0pt 5.0pt 5.0pt 5.0pt">
                                                                                        <p class="MsoNormal"><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Data
                                                                                                1</span><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">
                                                                                                <o:p></o:p>
                                                                                            </span></p>
                                                                                    </td>
                                                                                </tr>
                                                                            </tbody>
                                                                        </table>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt">
                                                                            <strong><span
                                                                                    style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Header
                                                                                    2</span></strong><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">
                                                                                <o:p></o:p>
                                                                            </span>
                                                                        </p>
                                                                        <table class="MsoNormalTable" border="0"
                                                                            cellspacing="0" cellpadding="0" width="739"
                                                                            style="width:554.25pt;border-collapse:collapse">
                                                                            <tbody>
                                                                                <tr style="height:15.0pt">
                                                                                    <td width="100%"
                                                                                        style="width:100.0%;border:inset 1.0pt;padding:5.0pt 5.0pt 5.0pt 5.0pt;height:15.0pt">
                                                                                        <p class="MsoNormal"><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Data
                                                                                                2<br>
                                                                                                Data 2<br>
                                                                                                <br>
                                                                                                Data 2<br>
                                                                                                Data 2<br>
                                                                                                <br>
                                                                                                Data 2<br>
                                                                                                Data 2</span><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">
                                                                                                <o:p></o:p>
                                                                                            </span></p>
                                                                                    </td>
                                                                                </tr>
                                                                            </tbody>
                                                                        </table>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444"><br>
                                                                                <b><br>
                                                                                    <strong><span
                                                                                            style="font-family:&quot;Arial&quot;,sans-serif">Header
                                                                                            3</span></strong></b>
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <table class="MsoNormalTable" border="0"
                                                                            cellspacing="0" cellpadding="0" width="739"
                                                                            style="width:554.25pt;border-collapse:collapse">
                                                                            <tbody>
                                                                                <tr>
                                                                                    <td width="730"
                                                                                        style="width:547.5pt;border:inset 1.0pt;padding:5.0pt 5.0pt 5.0pt 5.0pt">
                                                                                        <p class="MsoNormal"><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif">Data
                                                                                                3<span
                                                                                                    style="color:black">
                                                                                                    <o:p></o:p>
                                                                                                </span></span></p>
                                                                                    </td>
                                                                                </tr>
                                                                            </tbody>
                                                                        </table>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt">
                                                                            <strong><span
                                                                                    style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Header
                                                                                    4</span></strong><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">
                                                                                <o:p></o:p>
                                                                            </span>
                                                                        </p>
                                                                        <table class="MsoNormalTable" border="0"
                                                                            cellspacing="0" cellpadding="0" width="739"
                                                                            style="width:554.25pt;border-collapse:collapse">
                                                                            <tbody>
                                                                                <tr>
                                                                                    <td width="99%"
                                                                                        style="width:99.44%;border:inset 1.0pt;padding:5.0pt 5.0pt 5.0pt 5.0pt">
                                                                                        <p class="MsoNormal"><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif">Data
                                                                                                4<span
                                                                                                    style="color:black">
                                                                                                    <o:p></o:p>
                                                                                                </span></span></p>
                                                                                    </td>
                                                                                </tr>
                                                                            </tbody>
                                                                        </table>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt">
                                                                            <strong><span
                                                                                    style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Header
                                                                                    5</span></strong><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">
                                                                                <o:p></o:p>
                                                                            </span>
                                                                        </p>
                                                                        <table class="MsoNormalTable" border="0"
                                                                            cellspacing="0" cellpadding="0" width="739"
                                                                            style="width:554.25pt;border-collapse:collapse">
                                                                            <tbody>
                                                                                <tr style="height:15.0pt">
                                                                                    <td width="99%"
                                                                                        style="width:99.44%;border:inset 1.0pt;padding:5.0pt 5.0pt 5.0pt 5.0pt;height:15.0pt">
                                                                                        <p class="MsoNormal"><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif"><a
                                                                                                    href="mailto:emailone@gmail.com">emailone@gmail.com</a>;
                                                                                                <a
                                                                                                    href="mailto:emailtwo@gmail.com">emailtwo@gmail.com</a>;
                                                                                                <a
                                                                                                    href="mailto:emailthree@gmail.com">
                                                                                                    <span
                                                                                                        style="color:windowtext">emailthree@gmail.com</span></a>
                                                                                                <o:p></o:p>
                                                                                            </span></p>
                                                                                    </td>
                                                                                </tr>
                                                                            </tbody>
                                                                        </table>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444"><br>
                                                                                <strong><span
                                                                                        style="font-family:&quot;Arial&quot;,sans-serif">Header
                                                                                        6:</span></strong>
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <table class="MsoNormalTable" border="0"
                                                                            cellspacing="0" cellpadding="0" width="739"
                                                                            style="width:554.25pt;border-collapse:collapse">
                                                                            <tbody>
                                                                                <tr>
                                                                                    <td width="99%"
                                                                                        style="width:99.44%;border:inset 1.0pt;padding:5.0pt 5.0pt 5.0pt 5.0pt">
                                                                                        <p class="MsoNormal"><span
                                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif">Data
                                                                                                6<span
                                                                                                    style="color:black">
                                                                                                    <o:p></o:p>
                                                                                                </span></span></p>
                                                                                    </td>
                                                                                </tr>
                                                                            </tbody>
                                                                        </table>
                                                                        <p
                                                                            style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:15.0pt">
                                                                            <span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444"><br>
                                                                                <br>
                                                                                Lorem ipsum extra info;<o:p>
                                                                                </o:p></span>
                                                                        </p>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Thank
                                                                                you!<br>
                                                                                Name<o:p></o:p></span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">Company
                                                                                name<o:p></o:p></span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                        <p style="margin:0cm;line-height:15.0pt"><span
                                                                                style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#444444">&nbsp;
                                                                                <o:p></o:p>
                                                                            </span></p>
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            <p class="MsoNormal" style="margin-bottom:12.0pt"><span
                    style="font-size:1.0pt;font-family:&quot;Arial&quot;,sans-serif;color:white">_==--</span><span
                    style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">
                    <o:p></o:p>
                </span></p>
        </div>
    </div>
    <p style="font-size:9pt; line-height:12pt; font-family: 'Courier New','times roman',serif;
">
        <b>Lorem ipsum additional info</b><br>
        <br>
        <span style="font-size:12pt;  font-family: 'Cambria','times new roman','garamond',serif; color:#00a700;">Lorem
            ipsum additional info 2</span><br>
        <br>
        *******************<br>
        <br>
        <b>Lorem ipsum additional info 3</b><br>
        <br>
        <span style="font-size:12pt;  font-family: 'Cambria','times new roman','garamond',serif; color:#00a700;" Lorem
            ipsum additional info 4</span><br>
    </p>
    <div></div>
</body>

</html>

This code source is relating to the email thread the VBA code picked up. As you can see, there are three total tables (it starts with the most recent email at the top, and the oldest one at the bottom)m but it only picked up the latest two, which have a similar format, but not the third (oldest) one, which is the one I am looking for in this instance. The code picked up and extracted the first two tables, but displayed a runtime error before obtaining the third one.

If I can do anything else please let me know!
 
Upvote 0
I see the first two tables, each having two columns. However, I don't see the third one. Where is the third one?

I see that the other data for Header 1, Header 2, etc, are also within tables.

Is every email in this exact same format? If so, then we can refer to the data for Header 1, Header 2, etc, by index number.

Also, I believe you want the data from an email in a single row. Can you post the exact results that you would expect for the sample email?
 
Upvote 0
The third one would be the last email, since it is an html table of sorts, despite the visual structure being different. But yeah, I would be wanting to extract the info from the very bottom email. I'll get to work soon and type out what I am expecting to obtsin extracted in an excel workbook.

As far as email structure: Every email has the same form of tables and such, but not every email thread contains two tables of two columns and 18 rows. Some contain only one of those, some contain multiple, but theyre each sent in their own email. What every email thread contains for sure is the very bottom table (the one with header 1, header 2, header 3, etc) and thats the one I am trying to extract info into excel from.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Copy Outlook Email HTML Body as Table to Excel
Replies
6
Views
768
E1375
E
J
  • Question
Parse HTML table or extract Outlook body items to excel sheet
Replies
2
Views
198
Jaffirahamed
J
I
  • Question
Excel Code Not Working Anymore
Replies
7
Views
345
Domenic
D
J
  • Question
Importing Outlook Data
Replies
0
Views
360
Jack2010
J
L
  • Question
VBA Email extract problem
Replies
0
Views
321
Liverlee
L

Forum statistics

Threads
1,214,416
Messages
6,119,386
Members
448,891
Latest member
tpierce

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top