1 of 18 Design & Print Offline: Barcodes & Serial Numbers
Creating a Barcode 1.
Open the Design & Print software by double clicking on the Design & Print icon on your desktop
2.
The next page allows you to select a Product by either Category or by Typing in the Product Code. For this we will select the Labels for Letters and Envelopes option. Double click on this option
3.
You will need the product code for the labels you want to use. For this example we will use J8160. As you type the product code into the Quick Search box you will see the selection change as it fillers down and will eventually leave the product code you want to use. Click on the labels so they are highlighted blue and click Next in the top right hand corner.
2 of 18 Design & Print Offline: Barcodes & Serial Numbers
4.
You now have a choice of different designs that you can choose from. For this example we will select the blank landscape template. Click on the temple so it is highlighted in blue and click Next in the top right hand corner
5.
You will now be in the Design Tool. If you wish to create a one off barcode number please follow steps 5-7 if you wish to create a sequential barcodes then please follow steps 8 or 9 Click on the QR and Barcode tab on the left hand menu and then click the Add Barcode button
You can select if you would like the Whole page with the same information or whether each label has different information by selecting the Edit All or Edit One option on the right hand corner.
6.
Now the barcode wizard box will open and You will need to select the type of barcode that you require from the drop down list.
3 of 18 Design & Print Offline: Barcodes & Serial Numbers
7.
For this example I will use the Code 128 option. Type the barcode number into the blue highlighted box below the barcode drop down list. When you have done this click Finish. Please go to step 10
8.
To create a sequential barcode you will first need to create the sequential number. You can do this either by using the serial number option in Design and Print or export the data from an excel spreadsheet. i)
Firstly we will do this via the serial number function. You will need to select the Serial Number tab in the menu and click on Add Number.
ii)
You will need to fill out the information in the serial number box as requested. This number will be your barcode number When this is filled out click Finish.
4 of 18 Design & Print Offline: Barcodes & Serial Numbers
iii)
Now your serial number Will appear sequenced on your labels. Go to the QR and Barcodes tab and click Add Barcode
iv)
In the barcode wizard you will need to first select the barcode you are using from the drop down list (for this example we will use the Code 128) Then click on Merge
v)
You will now see that your Serial number appears on the left hand side in the Available serial numbers box. Click on the number and drag it across to the Enter numeric digits or characters box as advised on the screen.
5 of 18 Design & Print Offline: Barcodes & Serial Numbers
vi)
Once this has been dragged across (The serial number will appear As SN1 in the Enter numeric digits or characters box) click Finish in the top right hand corner.
vii)
The sequenced barcode will now appear on your label. If you wish you can now delete the serial number text box by clicking on it and clicking Delete in the top blue bar as shown. You are now ready to print your project. Please go to step 10
9.
To create a barcode using a Excel spreadsheet you will need to i)
Click on the QR and Barcode tab on the left hand menu and then click the Add Barcode button You can select if you would like the whole page with the same information or whether each label has different information by selecting the Edit All or Edit One option on the right hand corner.
6 of 18 Design & Print Offline: Barcodes & Serial Numbers
ii)
In the In the barcode wizard you will need to first select the barcode you are using from the drop down list (for this example we will use the Code 128) Then click on Merge
iii)
Click on the Browse for File button to locate your excel spreadsheet you wish to use
iv)
Selet your file from your computer and click Open
7 of 18 Design & Print Offline: Barcodes & Serial Numbers
v)
It will now come up with your merge file. You will need to remove the title so it does not show on your labels by unticking the first row box as shown.
vi)
Once you have done this click Complete Merge
vii)
You will now return to the barcode Wizard and you will see that your spreadsheet is now available in the Available Merge Data section. You will need to click on the title of your spreadsheet data and drag it across to the Enter numeric digits or characters box.
8 of 18 Design & Print Offline: Barcodes & Serial Numbers
viii)
Once this has been dragged across (The spreadsheet title will now be visible in the Enter numeric digits or characters box) click Finish in the top right hand corner.
10.
Your Barcode will now appear on the screen. You can move this to the required position on the label.
11.
Once you have finished you can click Preview & Print in the top right hand corner
9 of 18 Design & Print Offline: Barcodes & Serial Numbers
12.
If you are happy with your design you can now print it by selecting the Print Button in the top right hand corner. If you wish to make amendments before printing then select the Back button which is also in the top right hand corner. After you have made the amendments follow step 11 again to get back to this page and continue with the printing steps below.
13.
You will now get your printer options. If you are printing your project for the first time please click on Printer Properties. Please ensure that your printer is set to A4 paper and that there is no scaling or fit to size selected. This will need to be changed to 0% scaling or actual size – these options will vary from printer to printer so please select whichever is relevant to your printer settings.
10 of 18 Design & Print Offline: Barcodes & Serial Numbers
Creating a QR Code 1.
On Open the Design & Print software by double clicking on the Design & Print icon on your desktop.
2.
The next page allows you to select a product by either Category or by typing in the Product Code. For this we will select the Labels for Letters and Envelopes option. Double click on this option
3.
You will need the product code for the labels you want to use. For this example we will use J8160. As you type the product code into the Quick Search box you will see the selection change as it fillers down and will eventually leave the product code you want to use. Click on the labels so they are highlighted blue and click Next in the top right hand corner.
11 of 18 Design & Print Offline: Barcodes & Serial Numbers
4.
You now have a choice of different designs that you can choose from. For this example we will select the blank landscape template. Click on the temple so it is highlighted in blue and click Next in the top right hand corner
5.
You will now be in the Design Tool. You can select if you would like the whole page with the same information or whether each label has different information by selecting the Edit All or Edit One option on the right hand side. Next click on the QR and Barcode button on the left hand menu and click the Add Barcode button.
6.
The Barcode wizard will now appear on screen. Please select the QRCode option from the format drop down list.
12 of 18 Design & Print Offline: Barcodes & Serial Numbers
7.
Next you will need to select the type of code you want to use from the Code Type drop down list. The option for a QR code are: TEXT Email URL Phone Number VCard MeCard For this example we will select the URL code type.
8.
You will now need to type in the Information you wish to use for your QR barcode, for this example we are going to use the Avery UK website address. Type the information into the content box. When you have done this click Reload. The Sample View will then change to show your QR barcode. Now click Finish.
9.
Your Barcode will now appear on the screen. You can move this to the required position on the label or change its size on your label.
13 of 18 Design & Print Offline: Barcodes & Serial Numbers
10.
Once you have finished you can click Preview & Print in the top right hand corner.
11.
If you are happy with your design you can now print it by selecting the Print Button in the top right hand corner. If you wish to make amendments before printing then select the Back button which is also in the top right hand corner. After you have made the amendments follow step 10 again to get back to this page and continue with the printing steps below.
12.
The print options will now open up and you can now print your project onto your Avery UK product by selecting the Print option. Please ensure that your printer is set to A4 paper and that there is no scaling or fit to size selected. This will need to be changed to 0% scaling or actual size – these options will vary from printer to printer so please select whichever is relevant to your printer settings.
14 of 18 Design & Print Offline: Barcodes & Serial Numbers
Creating a Serial Number 1.
Open the Design & Print software by double clicking on the Design & Print icon on your desktop
2.
The next page will allow you to select a Product by either Category or by Typing in the Product Code. For this we will select the Labels for Letters and Envelopes option. Double click on this option
3.
You will need the product code for the labels you want to use. For this example we will use J8160. As you type the product code into the Quick Search box you will see the selection change as it fillers down and will eventually leave the product code you want to use. Click on the labels so they are highlighted blue and click Next in the top right hand corner.
15 of 18 Design & Print Offline: Barcodes & Serial Numbers
4.
You now have a choice of different designs that you can choose from. For this example we will select the blank landscape template. Click on the temple so it is highlighted in blue and click Next in the top right hand corner.
5.
You are now in the design tool. To add a serial number to your label please select the Serial Numbers tab from the left hand menu and click on Add Number.
6.
The serial number box will now appear. In the Serial Number Type Section you will need to choose either a numeric serial number or an alphabetic serial number. For this example we will use a numeric one. In the Serial Number Range Section you will need to enter Your START and END values. For this example we will use the Numeric serial number and will use 1 and 22 as our values.
16 of 18 Design & Print Offline: Barcodes & Serial Numbers
7.
If you want the serial number to start with zeros then you will need to click the Leading Zeros section and enter in the spaces you want. For example we will use the serial Number 0001. To get this number we need to select 3 zeros in front of the start value so we will need to select 4 as the number of spaces. In the Label section you can add a PREFIX and SUFFIX numbers (if you have any) to your code. In this example we had added Prefix 123 and Suffix 2001 You have filled in the information click Finish.
8.
The serial numbers will now appear on your labels. You will be able to amend the size, font and colour of the serial number as well as move the text box should you require the serial number to be situated differently on the label.
9.
Once you have edited your labels to your satisfaction click Print & Preview in the top right corner.
17 of 18 Design & Print Offline: Barcodes & Serial Numbers
10.
If you are happy with your design you can now print it by selecting the Print Button in the top right hand corner. If you wish to make amendments before printing then select the Back button which is also in the top right hand corner. After you have made the amendments follow step 9 again to get back to this page and continue with the printing steps below.
11.
The print options will now open up and you can now print your project onto your Avery UK product by selecting the Print option. Please ensure that your printer is set to A4 paper and that there is no scaling or fit to size selected. This will need to be changed to 0% scaling or actual size – these options will vary from printer to printer so please select whichever is relevant to your printer settings.
18 of 18 Design & Print Offline: Barcodes & Serial Numbers
