You want to create QR Code labels in large numbers. This may be for use cases such as—inventory management, product packaging, providing information at tourist sites, or making employee business cards.
In this article, we will give you two ways on how you can create QR Code labels.
Keep reading.
Way 1: Create QR Code Labels in MS Word Document on a Windows PC
To create QR Code labels in MS Word Document on a Windows PC, here are the steps you need to follow:
1. Save QR Code images in a folder
The first step is to save all your QR Code images (that you wish to add into MS Word) in a folder in one of your drives in your Windows PC.
If you do not have QR Codes generated, you can get them generated via Scanova’s Bulk QR Code Generation Service.
2. Create an Excel Sheet i.e. the Data Source
a. Create a new MS Excel. In a sheet of this Excel, in Column A, specify the file paths to each QR Code image saved in the folder (Step 1). One path in each row.
b. In this sheet, Column A needs to have a ‘field label’ in Row 1. This will be used as a reference in the Mail-Merge process in the subsequent steps. In the example shown below, we have named the ‘field label’ as ‘Address’.
c. Create and save this spreadsheet for later use
3. Create a Labels Template in MS Word using Mail Merge
a. Create a blank MS Word file
b. Click on the Mailings tab in the top navigation bar
c. Click on Start Mail Merge drop-down and click on Labels
d. A window Label Options will open. In the Label Information section, choose the label vendor from the Label Vendors drop-down menu (e.g. Avery US Letter)
e. Next, choose the exact product from the Product Number list that you will be using to print the labels (e.g. we have selected Avery 22805 Print-to-the-Edge Square Labels)
f. Click on OK when the selection has been made
g. Click on Select Recipients in the toolbar ribbon under Mailings and then click on Use Existing List. Navigate to the Excel data source file created in Step 2
h. A dialog window will open. In this window, select Sheet1 and check First row of data contains column headers. Then click on OK.
i. In the document, you will now notice placeholders for your labels
j. You’ll have to position the cursor in the first label cell
These instructions need to be followed:
- Press CTRL + F9 to open curly brackets, type INCLUDEPICTURE and then a space
- Next, press CTRL + F9 again, type IF TRUE and then a space
- Press CTRL + F9 again, type MERGEFIELD and then the name of the ‘field label’ you added in the Excel spreadsheet created in Step 2b
- Position the cursor just before the last nested curly bracket and type \d
- After completing these steps you should have ended up with the following in the first cell:
{INCLUDEPICTURE {IF TRUE {MERGEFIELD Address}} \d}
Tip: In some Windows 10 systems, CTRL + F9 initiates the Window’s Search application. In such cases, use CTRL + Fn + F9
k. Click Update Labels. It will populate all label cells with QR Code images stored in the folder. Also, the QR Codes will be arranged in the document as per their arrangement in the folder
l. Click on Finish & Merge and select Edit Individual Documents
m. A window Merge to New Document will open. In this window, select All under Merge Records and click OK. This will run the script in each label cell and hence, replace the actual script with the QR Code image referenced in it
n.A new MS Word document will open. As a result, you’ll see a list having each QR Code in its own label cell
0.We recommend you to save this document as a PDF and use this PDF to print the labels.
Way 2: Create printable QR Code labels PDF
You can create PDFs of printable QR Code labels using Best QR Code generator tool such as QR Batch.
Using QR Batch, you can:
- Specify the QR Code size, which means the labels you want per sheet. This can range from 1-80 labels per sheet.
- Select from a list of ten standard labels layouts—1, 4, 6, 9, 12, 20, 48, and 80 QR Code labels per sheet—compatible with Avery sheets
You can choose the size that is suitable to you. And download print-ready label in PDF document.
For more information, you can refer to this detailed guide on QR Code labels.
So, you can choose either of the two ways to create QR Code labels for your use case.
