A nested mail merge solution which can import a hierarchical data source into the template document.
This online mail merge tool allows you to nest mail merge sub-items in the document to reflect the hierarchical pattern of the data,
which allows you to easily fill the document with nested data or master-detail data.
You not only don’t need to write any code (such as VBA or MACRO), but you can also quickly get mail merge output without add-in. You only need to indicate the hierarchical name of the column in the Excel data table
and create a sub-tables in the MS word template to automatically fill in the corresponding document location.
Once you have prepared these two files, upload them to this mail merge service, then you will get the merged MS Word .docx file to download.
Features:
- This is a free online mail merge tool used to do MS Office document merging.
- Mainly to solve problems of the hierarchical data (one to many relationship, some people imprecisely say it's many to one relationship) that merged to MS Word template.
- It can be easier to merge multiple rows (records) into one page, no coding needed.
- Freely to use flexible custom template tags.
- Support unlimited tiers of hierarchical data merging.
- Supports automatic merging of multiple entries on one page, eliminating the need for unnecessary marks such as <Next Record>.
- Automatically creates table rows to fit dynamic table length.
- Use Excel spreadsheet or JSON format payload as input data source.
- Providing Office 2007(+) (docx) format output.
- Suitable for merging of emails, quotations, invoices, shipping orders, addresses, labels and business cards, etc.
- Provide multiple Excel worksheet data examples and Word templates to teach how to use the mail merge of Word and Excel.
- Support REST API, provide the connection for enterprise information system, realize system integration of mail merge.
- Provide enterprise technical support service plan.
Example 1: Two-tier hierarchical data merging
Template:
Data:
Example 2: Three-tier hierarchical data merging
Template:
Data:
Example 3: Business card
Template:
Data:
Upload template and data files to merge out the document: