Mail Merge with Record Loop Builder

The Mail Merge Loop Action Builder retrieves a group of records, loops through each record and merges that record with a mail merge template.

media_1483689627094.png

Select the record type that will be merged with the template.

media_1481653248456.png

The Record Criteria will be used to ascertain which records to retrieve from the database.

media_1481653308160.png

Values can be passed into Criteria by creating a parameter.

By enclosing a value in { } brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be statename.

Parameters will have the value substituted during the script execution.

media_1481653338047.png

If parameters are found in the Criteria, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

media_1481653369444.png

media_1481643190176-1.png

Select the Document Object Type that will contain your template.

media_1481643322085-1.png

The Template Criteria will be used to ascertain what document to be retrieved.

media_1481643368137-1.png

Values can be passed into Criteria by creating a parameter.

By enclosing a value in { } brackets, that flags the word as a parameter. The name of the parameter, in the picture, would be documentName.

Parameters will have the value substituted during the script execution.

media_1481643483651-1.png

If parameters are found in the Criteria, they wil be listed in the Name drop down.

Name – the name of the parameter within the criteria.

Type – type of value to be expected (String, Bool, Date, Decimal, Number).

Variable – the variable that will hold the value. The drop down will contain existing variables or type in a new variable name.

Click the Add button to add the parameter name and value to be substituted.

media_1481643494728-1.png

media_1481643537754-1.png

Click Yes to save the document as a Pdf.

File Path – the variable that will hold the path to the new document file. Note: this variable needs to be set before this point in the script.

Deleting the File Path variable name will bypass the saving file portion of the script.

media_1481643583941-1.png

Selecting Yes will send the document contents to the default printer.

Created Script

media_1481653496786.png

Add Text Criteria Parameter – maps a Criteria Parameter to a value to be substituted with.

Find Record By Criteria – retrieves the template record, in the database, that matches a Criteria and sets that record to a variable.

Get Record Content – gets the document content from the record.

New Document Item – creates a new DocumentItem and sets that to a variable.

media_1481653536226.png

Set DocumentItem Content – sets the newly created DocumentItem content to the record content variable.

Add Text Criteria Parameter – maps a Criteria Parameter to a value to be substituted with. This parameter is for the records.

Get Records – retrieves all records that match the Criteria.

media_1481653565042.png

Loop Record Collection – loops through all the records that were retrieved.

Document Record Mail Merge – generates the mail merge record with template.

Save Pdf File – takes a path and saves the final mail merge contents to that path.

Print Document – sends the final mail merge content to the default printer.