PipeDream enables you to print labels for the names and addresses in your names and addresses database.
If you are using a dot matrix or daisy wheel printer, the labels are printed in one column. If you are using a page printer with a RISC OS printer driver, you can lay out the labels for printing on label sheets which generally have three columns of labels on each sheet.
First, you need to prepare a file of names and addresses which will be used to print your labels.
1. Load your database of names and addresses.
2. Save the database with a different name to the original. This is for safety. As you are going to make a selection from the records, you do not want to overwrite your original database. After saving the database, check that PipeDream has changed the name of the file in the window to the new filename.
3. Make any selections or deletions required. In particular, ensure that the last column contains the last line of the address.
C | D | E | F | G | |
---|---|---|---|---|---|
1 | Southam School | Stratford Road | Southam | Warks | SO1 23B |
2 | Cambridge High School | East Road | Cambridge | Cambs | CB1 23B |
3 | Tatham Grammar School | Dallas Road | Higher Tatham | Lancs | LA2 12B |
4 | Tunstall School | Cantsfield Ave. | Tunstall | Cumbria | TU1 23B |
5 | Warrington High School | Widnes Road | Warrington | Cheshire | WA1 23B |
6 | Abbeystead Academy | Dolphin Road | Abbeystead | Lancs | AB1 23B |
7 | Settle High School | Sedburgh Road | Settle | N Yorks | SE1 23B |
4. Save the file of names and addresses in ASCII format with a different name to the original database.
This ASCII format file will be used to produce the labels.
Now you need to create your label template.
We have provided a label template in a file called Label in the directory called Labels in the PipeDream Examples archive.
1. Open the Label file.
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | @0 | |||||
2 | @1 | |||||
3 | @2 | |||||
4 | @3 | |||||
5 | @4 | |||||
6 | @5 | |||||
7 | @6 |
This is the label template for the names and addresses database shown above. It is 7 lines long, one line for each field in the database.
@0 represents the first column of the database, @1 the second column, @2 the third column, and so on.
The first label produced from the database above would be:
Joe Smith
Headmaster
Southam School
Stratford Road
Southam
Warks
SO1 23B
You can edit the Label file if you need to, to suit your own labels.
2. In the Page Layout dialogue box, the page length is set to 8, the top margin to 1 and the other margins to 0. This is necessary because each label is eight lines long, seven lines of text and one blank line. Again, you can change this to suit your own labels if you need to do so.
3. Save the label template file in the same directory as the names and addresses file in ASCII format.
If you are using a page printer proceed to the section below called Page Printers.
If you are using a dot matrix or daisy wheel printer, you can now print out the labels on your printer:
1. Ensure that the label template file is loaded.
2. Give the Printer Config command and enter the settings appropriate for your printer.
3. Give the Print command.
4. Set the Print to option to Printer.
5. Click Select on the Fill from database option to turn it on.
6. Type in the name of the ASCII format file of names and addresses.
7. If you have any blank fields in your database which you want to close up, click Select on the Omit blank fields option. For example, you may have the postcode as the last column and blank fields before it. This option will lift the postcode so that it appears on the line of the label immediately beneath the last address line. Note that if you have more fields after the postcode, these will come onto the label too. This is why it is best to delete from your ASCII format database those columns which you do not want on the label.
8. Click the Enter.
button or pressYour labels will be printed out in one column.
Now that you have prepared the file of names and addresses and the label template, you need to print the labels into a file, not onto the printer at this stage.
1. Ensure that the label template file is loaded.
2. In the Printer Config dialogue box, set the printer type to Parallel and ensure that the printer driver name field is blank.
3. Give the Print command.
4. Set the Print to option to File.
5. Type in the name you want to give to the file of labels. Just type in a leafname and PipeDream will put the file in the same directory as the label template file.
6. Click Select on the Fill from database option to turn it on.
7. Type in the name of the file of names and addresses in ASCII format.
8. If you have any blank fields in your database which you want to close up, click on the Omit blank fields option. For example, you may have the postcode as the last column and blank fields before it. This option will lift the postcode so that it appears on the line of the label immediately beneath the last address line. Note that if you have more fields after the postcode, these will come onto the label too. This is why it is best to delete from your ASCII format database those columns which you do not want on the label.
9. Click the Enter.
button or pressPipeDream creates a new file containing the labels.
10. Load the file of labels into PipeDream by dragging its icon onto the PipeDream icon on the icon bar.
A | |
---|---|
1 | |
2 | Joe Smith |
3 | Headmaster |
4 | Southam School |
5 | Stratford Road |
6 | Southam |
7 | Warks |
8 | SO1 23B |
9 | |
10 | Mary Brown |
11 | Head of Science |
12 | Cambridge High School |
13 | East Road |
14 | Cambridge |
15 | Cambs |
16 | CB1 23B |
17 | |
18 | Susan Smith |
19 | Headmistress |
20 | Tatham Grammar School |
You should see your labels arranged in one column as shown above.
Now you need to arrange them into three columns for your label sheets. The labels sheets we are working with in this example have three columns of eight labels.
To convert the single column of labels into three columns of labels, you should first mark the last third of the labels and move them to column B, then mark the middle third of the labels and move them to column C:
1. Press the End key to position the caret in the bottom cell, A480.
2. Note how many rows there are. Divide this figure by three. In our example, there are 480 rows, so dividing it by three gives the result 160.
3. Drag Select across cell A480 to mark it.
4. Press Ctrl-CGS (Go to cell).
5. Type in A321 (480 - 160 + 1) and click the Enter. This positions the caret two-thirds of the way down the rows.
button or press6. When the caret is positioned in cell A321, on the blank line above a label, click Adjust. This extend the marked block from cell A480 to cell A321.
7. Press the Home key to position the caret in cell A1.
8. Press the Tab key to position the caret in cell B1.
9. Press Ctrl-BM to move the marked block to column B.
10. Press Ctrl-Q to clear the marked block.
11. Press the End key to position the caret in the new bottom cell, A320.
12. Drag Select across the cell to mark it.
13. Press Ctrl-CGS.
14. Type in A161 (320 - 160 + 1) and click the Enter.
button or press15. When the caret is positioned in cell A161, on the blank line above a label, click Adjust. This extends the marked block from cell A320 to cell A161.
16. Press the Home key to position the caret in cell A1.
17. Press the Tab key twice to position the caret in cell C1.
18. Press Ctrl-BM to move the marked block into column C.
19. Press Ctrl-Q to clear the marked block.
There are now have three columns of labels in columns A, B, and C, each 160 lines long.
To tidy up the layout of the labels:
1. Click Select in the mark block box to mark the whole document
2. Give the Auto Width command (Ctrl-LAW).
3. Click Select in the mark block box to clear the marked block.
A | B | C | |
---|---|---|---|
1 | |||
2 | Joe Smith | Margaret Brown | Joe Smith |
3 | Headmaster | Director | Headmaster |
4 | Southam School | Abbeystead | Southam School |
5 | Stratford Road | Dolphin Road | Stratford Road |
6 | Southam | Abbeystead | Southam |
7 | Warks | Lancs | Warks |
8 | SO1 23B | AB1 23B | SO1 23B |
9 | |||
10 | Mary Brown | Jane Jones | Mary Brown |
11 | Head of Science | Headmistress | Head of Science |
12 | Cambridge High School | Settle High School | Cambridge High School |
13 | East Road | Sedbergh Road | East Road |
14 | Cambridge | Settle | Cambridge |
15 | Cambs | N Yorks | Cambs |
16 | CB1 23B | SE1 23B | CB1 23B |
17 | |||
18 | Susan Smith | Joe Smith | Susan Smith |
19 | Headmistress | Headmaster | Headmistress |
20 | Tatham Grammar School | Southam School | Tatham Grammar School |
Now you need to ensure that the labels fit exactly onto the page and are not broken up by page breaks.
In our example, the labels are 8 lines long, 7 lines of text and a blank line. Therefore, the number of printable lines on each page (the page length less any margins) needs to be divisible by 8.
As you can see in the Page Layout dialogue box, we have a page length of 66, top margin of 1 and bottom margin of 1, giving us 64 printable lines on each page.
4. Since the labels will be printed using a RISC OS printer driver, you need to set a font for the document using the Font command. Leave the point size set to 12. Homerton is a good clear font for label printing.
Now save the labels file in PipeDream format.
Printers and label sheets vary, but we have provided a template label sheet which you can work from to help you get exactly the right layout of labels for your particular set-up.
This is a file called Labelsheet and is in the directory called Labels in the PipeDream Examples archive.
To adjust the layout of your labels:
1. Load the document called Labelsheet by double-clicking Select on its icon.
2. Use the Font command to set the same font as you want to use for your labels.
3. Print out the file onto a blank piece of paper, using a RISC OS printer driver.
4. Compare the print-out with your label sheet and alter the column width, scale factor, page length, top margin or left margin settings until the template file fits your label sheet.
5. Make a note of the settings you used in the file Labelsheet and apply them to your file of labels.
6. Save Labelsheet so that you can use it for future reference.
7. Save your file of labels.
8. Print the labels out using a RISC OS printer driver.
For information on | See |
---|---|
Printing standard letters | Mailshots |
Selecting records from a database | Database Use |