Creating the label merge document #

The merge document page must be defined before labels can be printed.  This involves selecting the label size and layout, defining the fields to print on each label, and selecting the data source for the labels.

Step 1: Open a new word document and navigate to the “mailings” tab on the Ribbon at the top of the document.

Step 2: In the create section of the ribbon select the option for labels.

Step 3: Select options on the new pop-up window and find a liked product from the drop down box (e.g. Avery US Letter for Avery products)

Step 4: Decide on a specific type of label from the given product list and select ok

Step 5: Decide how you would like your print to be either a full page of the same labels or a custom set number of rows and columns of individual labels.

Step 6: Select ok and move the ribbon bar back to the mailings tab

Step 7: Select start mail merge and select the directory option from the drop down list.

Step 8: click on the “select recipients” option to the right of start mail merge and select “use an existing list” from the drop down box.

Step 9: Navigate your file system to the excel spreadsheet you would like to use and press open. (If a pop-up box opens up asking if you want to open this file it may pose risk if the file is harmful select yes)

Step 10: Decide on what sheet you would like to use from the excel spreadsheet or if you would like to use the entire document from the dropdown list. (Leave cell range alone)

Step 11: Create your label within the dotted boxes provided using the insert merge field option to insert the desired data from the excel spreadsheet into the document.

Step 12: add the Rule “next record” from the Rules option in the ribbon in order for each label to use the next set of data

Inserting a QR code into the document (WINDOWS ONLY) #

Step 1: select the insert table from the top bar on the default word ribbon.

Step 2: Click on the table option and choose “Draw table”.

Step 3: create a desired QR Code size (make sure to uncheck draw table once your table is drawn)

Step 4: inside the table press ctrl + f9.  A pair of { } will appear.

Step 5: inside the curly brackets type

{ DisplayBarcode (data you wish to create a QR Code out of can be a merge field) QR \q 3 \s 75 }

Example: { DisplayBarcode { MERGEFIELD ItemNumber } QR \q 3 \s 75 } - using mail merge for the data

Example: { DisplayBarcode 255 QR \q 3 \s 75 } - manual data entry

\s is the size of the actual QR code you can adjust this value to your liking

If at any point the brackets disappear and some kind of error comes up right click the error and select “toggle field codes”