Example Uses

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.

Use Case: A certificate for each course completed is emailed in a single email to each person.

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.

Use Case: Sending an email to each person with one PDF attachment (a letter) and another PDF attachment (a certificate).

The recipient receives two attachments that are based on different templates. The letter is derived from a Word document and the certificate from a Powerpoint presentation.

pdfMachine merge allows you to designate multiple dynamically generated PDF attachments.

Use Case: A group of rows in the spreadsheet are treated as 'line items' in the 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'.

Use Case:A different template is used based on the content of a mail merge field.

A different attachment is sent to recipients that are located .

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.

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.

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.

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.

Use Case: Create a data source for a mail merge

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

Use Case: Copy a merge profile and rename it

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

Use Case: Each PDF produced contains a customised chart