High quality labels may be printed from a text or csv file 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 ensure that the text data file is ready for action.
The text file containing the data should be a .txt or .csv file, with each "record" on a single line. The first line of the file should contain the names of the "fields" that will be referred to by Really Simple Labels. The fieldnames should be separated from one another by commas or tabs, and the data in each field shopuld be separated by commas or tabs.
So a typical example would start with the following lines:
name,publication,publisher, address1, address2, town,postcode,picture
Carol,Micro Decision,VNU Business Publications,32-34 Broadwick Street,,London ,W1A 2HG,id2.jpg
Jane,Personal Computer World,VNU Business Publications,32-34 Broadwick Street,,London ,W1A 2HG,id3.jpg
John,What Micro,VNU Business Publications,32-34 Broadwick Street,,London ,W1A 2HG,id4.jpg
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 Text or CSV file as the source type, then
browse to locate the file that contains the data.
Note that the Connection string and Recordset/Query are completed automatically.
The connection to the data file 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 data file contains the names used for the data 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
field in the data file.
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 field
in the data file 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 Fan Fold Tickets for printing?