How do you extract data from two or more sheets for labeling?

select * from [Sheet1$]
union select * from [Sheet2$]
union select * from [Sheet3$]

("Sheet1/2/3" stands for the different names of sheets, make sure all sheets contain the same number columns.)

Click "Run SQL" and then follow the below steps:

1. Select a Rule for Labeling: Click the "+" icon and custom a rule step by step(a label rule defines labels content based on a PDF template) and then save;
2. Click the "Label and Create as PDF" icon to form PDFs with labels.

This web tutorial will give you an overview of the procedure and you will handle this tool with ease!

More Related Q&A

• Send cards to different persons listed in a spreadsheet
• Create numerous envelops automatically
• Produce large number of cards based on a template
• Insert labels into PDFs with data extracted from a local datasource
• Add labels of names and addresses into PDFs
• Mail merge and change the appearance of labels
• Form many PDFs with same content but different data
• Batch produce PDFs with individual label info

TOP Q&A

• Convert images contain scan files to PDF
• Unlock secured PDF
• Print passwords protected PDF files
• Protect a PDF File with password
• Scan to PDF and mail it subsequently
• Remove restrictions from encrypted PDF
• Convert scan files to Acrobat PDF
• Protect PDF files or remove restrictions
• Convert Image to PDF
• How to Extract JPEG Image File from PDF files