Posted: March 15th, 2014 | Author:admin | Filed under:General, Generating QR Codes, How To Make QR Code Labels & Stickers, How To Make QR Code Labels & Stickers, How To Make QR Code Labels & Stickers, QR Codes Use Cases | 1 Comment »

• Avery 22805 Template Word
• Avery Labels 22825 Template
• Avery 22805 Template For Word

Here’s some step-by-step instructions on using a label template in MS Word 2010 to create QR code sticker labels from a pre-made set of QR codes using the mail-merge function. We’ve used the Avery 22805 label template (1.5″ x 1.5″ 24 per sheet) but you can use any digital label template you want.

Avery Label Template 22805 Avery 22805 Labels is related to Avery Templates. If you looking for Avery Label Template 22805 Avery 22805 Labels and you feel this is useful, you must share this image to your friends. We also hope this image of Avery Label Template 22805 Avery 22805 Labels can be useful for you. We will always give new source of image for you. Create brand recognition with the Avery 22805 Easy Peel 1 1 /2' x 1 1/2' white square print-to-the-edge labels! Featuring an Easy Peel sheet and a Pop-Edge, this set of labels is designed for quick, efficient application. Once you've customized your labels using a laser or inkjet printer, simply bend the label sheet back, peel your label off, and then fold the sheet back to a flat position. This online label creator is the most flexible way to add images and text to Avery products. With thousands of pre-designed templates to choose from, it's the most creative way to design your labels. If you just want to add basic text to your labels, we also have hundreds of Microsoft® Word templates available to download. Use Avery templates in Word for Mac. If you use Avery paper products, such as labels, business cards, dividers, name badges and more, you can use the Avery templates in Word. All you need is the product number. Go to Mailings Labels. In the Labels dialog, select Options.

The point we’re assuming you’re currently at is that you’ve already created your QR code images and have saved them locally into a folder on your computer, and the end result of the instructions shown below will be a sheet of labels containing each of these previously created QR codes.

Create A Data Source

The mail-merge process intially requires a “data source” which should be prepared first. The data source contains the path location on your computer for each of the indivdual QR codes images that will be displayed in each of the labels (24 in our case since we are creating 24 different stickers on a single sheet of labels). The simplest way is to create an MS Excel spreadsheet contining the image file paths for each QR code in column 1. This column also needs to have a field label in row 1 which will be used as a reference in the mail-merge process later on. We used the label “qrcodes”.

Create and save this spreadsheet for later use.

Open Your Label Template

Either open your digital template in MS Word (we downloaded our Avery 22805 label template from the Avery website) or use one of the templates pre-loaded into MS Word.

1. Select the “Mailings” command ribbon
2. Select “Start Mail Merge” and then “Labels”. Choose the template you require and press OK, or if you have already opened your own downloaded digital template just press Cancel (don’t know why this step has to be done when using your own template, but it won’t work if you don’t)

The Mail-Merge Process

1. Click on “Select Recipients” in the toolbar ribbon and then “Use Existing List” and navigate to the Excel data source file created above.

A dialog box will then appear – ensure that both “Sheet1” and “First row of data contains column headers” are both selected and press OK.

2. Position the cursor in the first label cell:

2. 1. Press CTRL + F9 to open the curly brackets, type INCLUDEPICTURE and then a space.
   2. Press CTRL + F9 again, type IF TRUE and then a space.
   3. Press CTRL + F9 again, type MERGEFIELD and then the name of the field identifier you used in your Excel spreadsheet created above. We used “qrcodes” so we type that.
   4. Cursor across to the 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 qrcodes}} d}

NOTE: You can also include other columns of information in your data source (such as a text label associated with each QR code), and the scripting could be extended at this stage of the process to include another MERGEFIELD parameter that pulls that data into the label as well.

3. Click on “Update Labels” which will populate all label cells with the mail-merge scripting. Each script is set up to pull consecutive images from your Excel data source file. eg; first listed QR code into the first cell, second QR code into second cell, third QR code into third cell, and so on.

4. Click on “Finish & Merge” and select “Edit Individual Documents”. Select Merge “All” Records and click OK. This will run the script in each label cell and replace the actual script with the QR code image referenced in it.

A new document will be opened showing each of the individual QR codes in their own label cell.

Avery 22805 Template Word

Save and print. Done!

Create QR Codes in Bulk Using Our Batch Processing Feature

Avery Labels 22825 Template

A standard part of the QR Stuff paid subscriber feature set is the ability to automatically generate batches of up to 500 QR codes by simply uploading a spreadsheet file containing the details of up to 500 QR codes. The end result is a whole heap of individually and uniquely named QR codes that are ready to be imported into a label template using the process outlined above.

Avery 22805 Template For Word

Click here for our batch processing user guide, or visit our FAQ section.