Example Uses

pdfMachine merge is a powerful tool which sends batches of personalized emails with personalized PDF attachments. It can be configured to perform the merges in a number of different ways.

Use Case: A certificate of achievement is emailed to each person listed in the spreadsheet.

This is a typical use of pdfMachine merge, where there is a one to one relationship between rows in the spreadsheet and emails sent.

Go to example

Use Case: One or more certificates of achievement are emailed to each person listed in the spreadsheet.

Each person may have completed a number of courses, so instead of sending them multiple emails with a single attachment, one email is sent with multiple attachments.

Go to example

Use Case: Sending an email to each person with one PDF attachment containing grades and another PDF attachment containing a certificate.

The grades PDF is derived from a Word document and the certificate from a Powerpoint presentation.

pdfMachine merge allows you to send any number of dynamically generated PDF attachments.

Go to example

Use Case: Each group of 'line items' in a spreadsheet produce an email with attached PDF.


Adjacent rows in the spreadsheet with the same email address are used to produce a single PDF invoice with line items. This is an advanced example where the 'rows to email' method is 'One or more rows generates a email'. This example also demonstrates use of a HTML file as a template.

Go to example

Use Case: Rows to email - each row appends to the PDF.

Each row in the spreadsheet produces a PDF - however if adjacent rows in the spreadsheet have the same email address, the PDFs are combined together and only one email with one attachment is sent. This is an advanced example where the 'rows to email' method is 'Each row appends to the PDF attachment'.

Go to example

Use Case: Attach the same static (existing) file to each email sent

Along with the dynamically generated PDFs, you can attach files that already exist to each email sent. e.g The same file is sent to each person in the spreadsheet.

Go to example

Use Case: Attach different (existing) files for each email sent

You can attach files that already exist to each email sent. These files can be different for each email. e.g A n existing file specific to the recipient is sent with each email. Merge fields from the spreadsheet are used to specify which file goes with which email.

Go to example

Use Case: Apply a password and a watermark to PDF files to be mail merged

You can apply security settings and/or stamps to the PDF files that are attached to each email sent. e.g A PDF is password protected and stamped as confidential then sent as an email attachment.

Go to example

Use Case: Create a data source for a mail merge

How to create an Excel or CSV data source for a mail merge operation.

Go to example

Use Case: Copy a merge profile and rename it

Go to example

Use Case: Produce a batch of PDFs that are the same except each one has a unique number stamp

Go to example