pdfMachine merge

Creates and sends batches of personalized emails with personalized PDF attachments.

pdfMachine merge will insert the personalized details from a data source into your template to create individual, personalized emails and PDFs in bulk.

You no longer need to manually create these emails and attach the PDFs yourself.

pdfMachine merge is a utility that is licensed with pdfMachine ultimate

Watch the Explainer.

Watch a video to see how to use it

See Examples

The email body and PDF attachments for all of the emails have the same layout, however parts of the content are customized for the individual email. Data is automatically transferred from a data source such as Excel into a template producing a personalized PDF attachment to an email.

For example

  • each email can refer to the recipient by name
  • the attached PDF can have individual statement information, with line items
  • each PDF can have an individual password
  • an email can have multiple personalized PDFs attached
Read about more of the powerful features of pdfMachine merge here.



pdfMachine merge is fast. Much faster than using Word to do a merge. This makes a big difference when you have a large number of emails to send.


pdfMachine merge is highly configurable. The different modes allow the data source to be distributed to the emails and attachments in various ways.

Send an email for every row in the data source

This is the default mode. Each row in the data source file will generate an email with attachment(s) based on a single row of data.
See Example

Rows generate separate PDF attachments for an email.

Each row in the data source file will generate an attachment. Emails are grouped together on consecutive email address.

e.g. A student has completed 3 courses. One email with 3 attached certificates is required. The data source file has 3 rows which all have the same email address, but also has other fields which are course specific. In this case, 3 attachments will be generated and sent in a single email.
See Example

Rows are used as line items within the email / PDF attachment.

Consecutive rows in the data source file that have the same email address can be "bundled" together and only one email is sent per bundle.

Note: If you want to have a variable number of rows per email address in the data source file, we recommend using HTML templates with Liquid templating language and/or Javascript.

e.g An invoice or statement. The data source file has many rows which all have the same email address, but have other fields which are line item specific. In this case, a single attachment will be generated and sent in an email. The line item information can be inserted into the PDF or the email.
See Example

Multiple PDF attachments

More than one PDF attachment can be sent in each email. Multiple personalized PDFs can be dynamically created and attached. Existing files can also be attached. These can be named specifically or referred to by a merge field allowing different existing attachments for different recipients. These can be named specifically or referred to by a merge field allowing different attachments for different recipients.

See Example

Attach existing PDFs

PDF files that you already have can also be attached to the email. If desired, the file can be different for each email (using a merge field to designate the file name). Or the same file can be attached to all emails by entering a direct path name.

Existing PDFs can be password protected or have a stamp/watermark applied to them.

See Example

Save the profile for next time

Multiple profiles can be created. Profile settings are saved making it easy to come back to the profile later. e.g. you might have one merge profile for a monthly statement you send out and another for an annual mail out.


A history of merges performed is maintained - making it easy to find emails you have previously sent.

Personalized security

PDF security can be set for the attachments. Each PDF attachment can have its own security settings by using a merge field as the password. e.g. a password specific to a recipient.


Powerful formatting capabilities using the Liquid templating language and/or Javascript within the HTML templates.

See details and examples

HTML email

The email body is produced using a WYSIWYG HTML editor making it easy to create good looking emails yet providing you with the power of HTML. Read here for more information on HTML emails.