Create a table in Excel, exactly like the one below…

Make a three column table in Excel that we will use to create barcodes.  The three columns are titled 'Type' 'Label' and 'Barcode'

Click "Save As"…

How to save the barcode table

Save the file in this exact location…

The file location should be \MyDocuments\MyDataSources\ and the filename should be BarCodeExamples.xlsx

Open a new Word document and select "Mailings"…

Open a new word document and click the 'Mailings' tab

Click "Labels"…

Select 'Labels' from the Mailings Menu

Select these exact labels…

Select the Avery 5161 Easy Peel Labels

Click the "New Document" button…

Click the 'New Document' button

And your New Document should look like this…

Make sure your new document has the outline of the labels

Make sure to click the "Mailings" tab in your new doc…

If the 'Mailings' tab isn't selected, make sure it is.

Select your "recipients" (hint: they're really your barcodes)…

Click 'Select Recipients' and 'Use an Existing List…'

Choose the file we saved earlier…

Click 'Select Recipients' and 'Use an Existing List…'

Select the proper sheet…

Make sure 'Sheet 1' is selected and click 'OK'

Insert a "Merge Field" called "Type"…

Click 'Insert Merge Field' and then click 'Type'

Make sure the merge field is in the first label…

Make sure the mergefield is in the first label.

Insert a second "Merge Field" called "Label"…

Click 'Insert Merge Field' and then click 'Label'

Make sure the "Label" field looks like this…

Make sure the mergefield for 'Label' is right next to the 'Type' mergefield

Finally, insert the "Barcode" merge field…

Do the same thing for 'Barcode'

Format the label a little…

Add some separator characters and put the barcode on a new line within the label

This is the most important part of this tutorial…

You MUST change the word 'Mergefield' to 'Mergebarcode' for the barcode field, or this will never work

Change the highlighted “FIELD” to “BARCODE”…

The 'MERGEFIELD' should now appear as 'MERGEBARCODE'

Add the type of barcode here…

Enter 'CODE128' after the field type. This tells Word to use the CODE128 barcode font.

This is how you add the other barcode labels…

Insert a 'Next Record' mergefield in the second label

Make sure you precede the other labels with this code…

Make sure the 'Next' mergefield comes before the next barcode mergefields.

Now it's time to copy and paste, just like first grade…

Select all of the mergefields from the first barcode label.

And paste...

Copy mergefields to the second label after the 'next' mergefield.

Rinse and repeat…

Repeat the process again for the third barcode label

Don't forget to change the barcode type…

Select CODE129

To this…

Change CODE129 to CODE39 for this barcode label.

And don't forget to change this barcode…

Change CODE129 to QR

To this…

Make sure this is changed to QR

Now it's time to put it all together…

Click 'Finish and Merge' and 'Edit Individual Documents'

Make sure "All" is selected and click "OK"…

Select 'All' and click 'OK'

BAM! Call your Mom and let her know what you just did…

Your barcode should now appear like this with a CODE128 in the first label, a CODE39 in the second label, and a QR code in the third label.

Let's arrange the codes a little better…

Click the 'image format' icon.

Select this option…

Choose 'Square' as the type. This allows you to move the barcode position.

Now you can easily move the barcode…

Move the barcode over to the right side of the label.

Arrange the other barcodes…

Move the other barcodes over to the right side as well.

Click "File"…

Click 'File' to print your barcodes.

And print…

Click 'Print' and follow the prompts. Your Barcodes should now print.