In-Table List with Filtering Grouping and Ordering in Email Document Leave feedback

Note

In this article, we will use GroupDocs.Assembly to generate a In-Table List with Filtering, Grouping, and Ordering report in Email Document format.

Practicing the following steps you can create In-Table List with Filtering, Grouping, and Ordering Template in MS Outlook 2013.

1. Create a new Email.
2. Press “Insert” tab to insert the table.
3. Insert a 2x2 table.
4. Save the template.

As a report developer, you are required to represent managers’ contract information with the following key requirements:

• Report must be in .eml or .msg format.
• It must add email recipient, css and subject of the email.
• Report must show each customer along with sum of prices of his orders.
• It must represent all the information in tabular form.

Tip

For detailed technical information about syntax,expressions and report generation by the engine, please visit: Working with GroupDocs.Assembly Engine

Please download the sample In-Table List with Filtering, Grouping, and Ordering document we used in this article:

• in-table-list-with-filtering.msg

Note

The example reads the shop data described in The Business Layer.

import json
from datetime import datetime

from groupdocs.assembly import DataSourceInfo, DocumentAssembler

def parse_dates(item):
    # JSON has no dates: turn the order dates into datetime objects for the template
    for key in ("OrderDate", "ShippingDate"):
        if key in item:
            item[key] = datetime.strptime(item[key], "%Y-%m-%dT%H:%M:%S")
    return item

with open("orders.json", encoding="utf-8") as f:
    orders = json.load(f, object_hook=parse_dates)

assembler = DocumentAssembler()
assembler.assemble_document("in-table-list-with-filtering.msg", "in-table-list-with-filtering-report.msg", [
    DataSourceInfo(orders, "orders"),
    DataSourceInfo("Harbor Lane Provisions <orders@harborlane.example>", "sender"),
    DataSourceInfo(["Quayside Bistro <orders@quaysidebistro.example>", "jonas.weber@harborlane.example"], "recipients"),
    DataSourceInfo("amara.osei@harborlane.example", "cc"),
    DataSourceInfo("In table list with filtering", "subject"),
])

Binary file (MSG, 38 KB)