<< Click to Display Table of Contents >> Navigation:  SPM > SPM > Reports > Create an MS Word Template

A Microsoft Word template can be used within SPM to create customized labels, forms, or reports. This document describes how to create a Word template. The specific use of the template and the EQuIS data available will be described in reports or other instructional topics that have incorporated the use of the Word template as an option.

 

The template can contain static text or images combined with EQuIS data. For example, each sample label can have a static company logo and general instruction combined with sampling data, such as location code and sample ID. EQuIS data can be in the form of text or bar codes.

 

 

Preparatory Steps

 

1.Select the output format by determining the page dimension and print areas. For example, when printing to a form containing 8 labels per page, setup the page based on where each label print area starts and ends. This may require a few printing alignment trials using a template with test data.

2.The exact name is required in the template to pull the correct EQuIS data. For example, in the SPM Labels report, the MergeField Field name text in the template must match exactly the Excel output column header names. Read the report's documentation article for more details on how to get the exact names of available EQuIS data to print. For example, the MergeField Field name text options are listed under Field Label column in the table on the SPM - Labels report article.

 

 

Creating the MS Word Template

 

1.Open a blank document and save as a Word template.

2.Insert all static text and images in their intended printing places.

3.To insert EQuIS data:

a.Use the cursor, click the starting print point of the data field.

b.On the menu or ribbon row, select the Insert tab. Find the Explore Quick Parts icon, click the drop-down arrow, and then select Field.

c.On the Field window, on the Field names list select MergeField.

d.On the Field Properties section, leave the format set to none and type into the Field name box the exact data field name (as described above).

e.The Field Options section is optional. If a text descriptor of the inserted data field is needed (e.g., the field name, the column name, or an instruction), check the text to be inserted before or the text to be inserted after box and then key in the text.

4.Repeat Step 3 for as many data fields that are needed and can fit into the print area. For alignment, estimate the length of the field when placing other data fields on the same line. Note that bar codes will need a bigger square or space.

5.At the beginning of what should be a new label, use directions in Step 3 to add a "<< NEXT RECORD >>" field. This field should have a Field Name type of Next. This will ensure that the next label is generated with the next data record.

 

 

 

Importing the Template

 

The completed Word template needs to be imported into EQuIS to become available for use. Please refer to the Import a COC Template for COC Report article on how to import the completed Word template. For Step 10 in that article, refer to the specific report or instructional topic for the PLACE_TYPE column value.