In-Table List With Alternate Content in Email Document

Note
In this article, we will use GroupDocs.Assembly to generate a In-Table List With Alternate Content report in Email Document format.

In-Table List With Alternate Content in Email Document

Creating a In-Table List With Alternate Content

Practicing the following steps you can create In-Table List With Alternate Content Template in MS Outlook 2013.

  1. Add a new email.
  2. Press “Insert” tab to insert the table.
  3. Insert a 2X3 table.
  4. Save the template.

Reporting Requirement

As a report developer, you are required to represent your clients and their prices 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 product along with its price.
  • It must show sum of all the prices.
  • It must represent all the information in tabular form.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

Products

Order Price

<<if [!Any()]>>No data

<<else>><<foreach [in orders]>><<[Product.ProductName]>>

<<[Price]>><</foreach>>

Total:

<<[Sum(c => c.Price)]>><</if>>

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

Download In-Table List With Alternate Content Template

Please download the sample In-Table List With Alternate Content document we used in this article:

Generating The Report

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-alternate-content.msg", "in-table-list-with-alternate-content-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 alternate content", "subject"),
])

The following sample file is used in this example: in-table-list-with-alternate-content.msg

The following sample file is used in this example: orders.json

Binary file (MSG, 48 KB)

Download full output

Close
Loading

Analyzing your prompt, please hold on...

An error occurred while retrieving the results. Please refresh the page and try again.