How to extract useful data from database for labeling?

1. Free Download and open A-PDF Label (PDF mail merge) ;
2. Click the "Open excel file" icon to open a excel file as datasource to be labeled;
3. Input your wanted data type name in SQL Box, for example " select Name, City, Address, Phone from [Sheet1$]", if you just want to extract Name and Address data, you can input " select Name, Address from [Sheet1$]";

4. 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;
5. Click the "Label and Create as PDF" icon to form PDFs with labels.

More Related Q&A

• Put data to exact location in pages
• Align labels in PDF documents
• Define name pattern for output PDF
• Create customized label text