Overview:

MergeUp provides a powerful set of template commands that allow you to interact with and modify the underlying structure of your Word, Excel, PowerPoint, or PDF document. These commands enable you to create dynamic and customized documents based on your specific needs. This overview article will introduce you to each of the MergeUp template commands and provide a brief description of their purpose. You can click on the links to access detailed articles for each command.

Purpose:

The purpose of MergeUp template commands is to give you fine-grained control over your document generation process across Word, Excel, PowerPoint, and PDF. These commands enable you to manipulate variables, execute JavaScript code, conditionally include content, insert dynamic images and links, and iterate through data — all within your document templates.

Template Commands:

Command	Syntax	Article	Description	Word	Excel	PowerPoint	PDF
EXEC / #!	{# EXEC ... #} {#! ... #}	About EXEC	Enables the evaluation of JavaScript code without inserting anything into the document.	✓	✓	✓	✓
Expression	{# @@expressionAlias #}	Using Expressions	Inserts the result of an expression into the document, replacing the command with the evaluated value.	✓	✓	✓	✓
FOR / END-FOR	{# FOR loopVar IN loopArr #} {# END-FOR loopVar #}	About FOR	Allows looping through child data in the document, repeating content for each item with defined formatting.	✓	✓	✓	-
HTML	{# HTML ... #}	About HTML	Interprets HTML tags within the document, applying standard HTML formatting to the content.	✓	-	-	-
IF / END-IF	{# IF condition #} {# END-IF #}	About IF	Enables conditional content inclusion, showing content between IF and END-IF tags only if the condition is true.	✓	✓	✓	-
IMAGE	{# IMAGE ... #}	About IMAGE	Dynamically inserts images into the merged document using either public URLs or static resource developer names.	✓	-	✓	-
INS / #= / #	{# INS ... #} {#= ... #} {# ... #}	About INSERT	The most common tag for inserting dynamic data from queries or JavaScript into the final document.	✓	✓	✓	✓
LINK	{# LINK ({ url: obj.url, label: obj.name }) #}	About LINK	Defines URLs and labels for hyperlinks that are inserted into the document with hyperlink formatting.	✓	-	-	-
CONFIG	{# CONFIG ... #}	About CONFIG	Enables modification of PDF text field appearance and behavior in the final document. PDF template only.	-	-	-	✓

Next Steps:

• Explore detailed articles for each command to harness the full potential of MergeUp's template commands for your document generation needs.