Modifying Columns in Word template tables
You can use the SQL query to create or update the column information in the Edit Columns window. If no columns are defined, you are prompted to create column definitions from the SQL query. The table columns must match SQL query to ensure the table displays data as expected.
- This option is available in Microsoft Word only after installing application Mail Merge for Microsoft Word and cannot be accessed from the application Web Client.
- If you update the SQL query, you may be prompted to update the table columns. If you click Yes, the Edit Columns dialog box opens and reloads the table columns for you to format if necessary.
To modify table columns:
- Access the Mail Merge Field Editor. For more information see Modifying Merge fields in a Word template.
- Select the table field you require to modify.
- Click .
In the Edit Columns window, you can click in the column grid to view and edit an existing column data. You can also click Add Column to add a new column at the end of the list.
- Caption
- The text that is displayed in the first cell of a column.
- Width
- The relative width of the column. By default, the value in this field is set
to 1.
For example, if there are 6 columns each set to a width of 1, and one width is changed to 10, the width is 10/10 + 1+ 1+ 1+ 1+ 1 = 10/15 = 66.67% or 2/3 of the width of the entire table.
- Alignment
- The alignment of the text in the cell. You can change the alignment from Default to Left Justify, Right Justify, and Center Justify.
- Format Type
- The type of formatting that must be applied to this field. These are the
possible values:
- (none)
- Fixed
- Integer
- DateTime
- Percent
- Currency
- User
- Phone
- Owner
- Boolean
- Pick List ID
- Pick List Code
Note: If selected, from the Format Type list, select the name of the pick list you require to define. - Format String
- The string that must be used for the selected Format Type.
- Footer Type
- The type of footer that must be used. For Example: None, Sum, Minimum, Maximum, Median, or Mean.
- Footer Text
- The type of footer text that must be used for the footer type.
- DB Name
- The name of the field in the database as referenced in the SQL query.
- Click to remove the selected column from the list.
- Click to move the selected column one position up. If the column is already in the first position, this action has no effect.
- Click to move the selected column one position down. If the column is already in the last position, this action has no effect.
- Click to add any columns that require to be added based on the SQL
Query. See Modifying SQL in a Word Template SQL Merge field
If your table contains columns that are not listed in the SQL query, the columns in the merged document do not contain any data.