2018.1

Note
The Objectif Lune Printer Driver will naturally add a margin to the PDF generated
by this task. If your PDF is full bleed you will not get the desired results using this
option.
l A DOC (Word Document) file which is the result of the mail merge. This output is only
available when doing a mail merge.
Task properties
General Tab
l
Microsoft Word Document: Enter a Microsoft® Word® document or template, or click
the browse button to navigate to the location of the document. The supported extensions
are: *.doc, *.docx, *.dot and *.dotx.
l
Perform Mail Merge: Check when providing a Microsoft® Word® document or template
configured for mail merge.
l
Use settings specified in document: Selected to instruct the task to use the
connection string and SQL statements stored in the DOC file. There is no guarantee
that the database, connection string or statement are still valid, especially if the
DOC file was moved or sent to someone else.
l
Use custom settings: Override the mail merge settings in the Microsoft® Word®
document and lets you specify your own.
l
Connection String: The connection string to any ODBC database supported by
PReS Workflow. You can use the Browse button to open an existing File DSN, or
use the Database Button to open the ODBC connection interface.
l
SQL Statement: An SQL statement that is understood by the database you are
using and that will return a series of records that the Microsoft® Word® template is
expecting. Note that no validation is made on SQL statements except if they are for
Microsoft Access and Excel data files. You can use the Test Connection button to
test the SQL and connection string.
l
Test connection: Checks if the Connection String and SQL Statement are valid,
and if the resulting recordset is understood by the Microsoft® Word® document.
This is optional, though highly recommended.
Page 372