Difference between revisions of "Including Tables in a Word Merge Document"

Revision as of 14:54, 9 October 2013

You can also add data to one or more existing tables in the resultant MS Word document if you have multiple records that you need to include.

In the MS Word document you must create a table with the relevant number of columns. The table should only include a single row with the column headings (the heading do not have to match the field names within SmartSimple.)
You do not have to create form fields within the table. New rows will be created automatically and populated with data in the order specified in in the MS Word Merge Custom Field Values section.
Tables should be included at the very end of the Values section.
The table you create in MS Word for the example above would look like this:

Used to pull in list of activities, contacts, users, companies, notes, associations, transactions, level-1, utaproviderL1, utaproviderL2, utaconsumerL1 or utaconsumerL2 into the Word Merge document.

For example: to include all Level 2 Activities related to a Level 1 entity you could use:

table_1=[#(?object=activity)|~description~|~statusname~|~startdate~|~enddate~|$1139409$|#];

Be sure there are no spaces between the pipes (|) and variables.
In the example below the first table (identified by position and referenced as table_1) is set to the records associated with the entity.

@@ Line 7: / Line 7: @@
 ===Using Object [#...#]  syntax===
-* Used to pull in list of activities, contacts, users, companies, notes, associations, transactions, level-1, utaproviderL1, utaproviderL2, utaconsumerL1 or utacomsumerL2 into the Word Merge document.
+* Used to pull in list of activities, contacts, users, companies, notes, associations, transactions, level-1, utaproviderL1, utaproviderL2, utaconsumerL1 or utaconsumerL2 into the Word Merge document.
 :''For example: to include all Level 2 Activities related to a Level 1 entity you could use'':
   table_1=[#(?object=activity)|~description~|~statusname~|~startdate~|~enddate~|$1139409$|#];