High quality labels may be printed from Excel using AnyLabels, Really Simple Labels or Barcodes & Labels for Office. This page illustrates the procedure using Really Simple Labels, but the procedure is virtually identical when the other products are used.
First of all it simplifies the procedure if the first row of the Excel worksheet contains names that you can recognise as field names for the data that will appear on the labels. For example:
Now there are just a few simple steps to complete the operation (Click on images to see enlarged):
1. Open Really Simple Labels (or AnyLabels).
2. From the File menu select Printer Setup then choose the target printer.
You can also use the printer preferences button to check for page settings, etc.
3. From the Edit menu select Label size to specify the size of the labels you will be printing (or enter values for the height and width of the labels and the number down and across a printer page).
4. Select Edit .... Data source,
choose MS Excel Workbook as the source type, then browse to locate the Excel file that contains the data.
Note that the Connection string is completed automatically, but the Recordset/Query box needs to contain the name of the worksheet containing the data, eg. select * from [Sheet1$] - the square barckets and dollar symbol are required!
The connection to the spreadsheet may be tested by pushing the Test connection button. Push OK when done.
Note that in this example we have assumed that the first row of the worksheet contains the names used for the data columns/fields.
5. Choose Edit ... Designer to open label template designer.
Once the Designer window is open you can add elements to the design by either right-clicking on the label surface and selecting the type of element you wish to add, or clicking on one of the icons in the toolbar.
6. Add a text block element to the
label by using step 5 and then clicking on the label
surface. Text blocks are displayed with the default text
Once added, an element may be moved by dragging it around the label surface, or resized by holding down the Shift key and dragging the lower right corner of the element.
7. A text block may contain fixed
text (ie. appears on every label) or text taken from the
To edit fixed text select the text block by clicking on it, then right-click on it and choose Properties from the pop-up menu displayed. The contents of the block may be edited by typing the required content in the dialog.
The dialog may be closed by pushing the OK button.
8. To use text from a column/field
in the spreadsheet select the text block by clicking on it,
then right-click on it and choose Properties from the pop-up
In the Text element properties dialog push the radiobutton labelled Field, then select the required field from the drop-down list of fieldnames.
9. Continue adding elements until
you are satisfied with the design, then push the
left-pointing arrow in the toolbar to return to the main
Now select File ... Save template to save the template with a suitable name.
Labels may now be printed by selecting File ... Print.
Need Self Tie Loop Lock Labels to print on?