Use data from MySQL to generate a PDF with barcodes and send it to an e-mail address.
Run the specified SQL Query against a MySQL database to obtain the information needed to generate barcode images and create a PDF file containing the images, then send the file to the specified recipients via e-mail.
Variables
MySQL Database with the data needed to create the PDF file.
Date and time where the processing of your sequentially sorted data should begin. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.
SQL Query create the content of the PDF file in HTML format.
SQL Query to create the data needed for generating the barcode images.
SQL query to use to determine the end point of the data to process.
SQL Steps to run after the e-mail has been sent.
Parameters to use in your SQL queries, if any. Refer to slide out help for more information.
Specific custom_nnd_id parameter to use in your SQL queries, if needed.
Specify parameters to control the general structure of the PDF file created.
Specify the name of the PDF file to create and attach to the e-mail. Can use dynamic values.
SMTP Server to use.
If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.
Addresses to place in the To field of the e-mail. Multiple values must be separated by commas.
Addresses to place in the Cc field of the e-mail. Multiple values must be separated by commas.
Addresses to place in the Bcc field of the e-mail. Multiple values must be separated by commas.
Subject content of the email.
Body content of the email.