Open Office Continuous Mail Merge Labels
Here's how to do labels.
First, get your data in a spreadsheet, text file, address book, and create a database. You can do this by choosing File > New > Database.
This post contains instructions for spreadsheets.
This post contains instructions in step 2 for spreadsheets or text files.
Then, once you've got the database set up in OpenOffice.org, you're ready to go.
1. Choose File > New > Labels. (To do Envelopes, open an OpenOffice.org Writer document, and choose Insert > Envelope.)
2. In the Labels tab of the Labels window, select the database you created in the Database dropdown list. You're looking for the name of the database you created by choosing File > New > Database, not the spreadheet, addressbook, or text file containing the data.
(Click the picture to see a larger image.)
3. Select a table from the Table list. This will be Sheet1 or whatever the sheet name is, if you are using a spreadsheet to hold your data.
4. Select the first field you want to use from the Database Field list.
5. Click the arrow next to it to insert it in the Label Text field.
Type a space after the field and you can add the next field, such as LastName.
6. Use the Database Field list to insert any other fields you need. If you want fields on the second line, click after the last character of the last field you inserted, in the big text box, and just press Enter. If you need to change the arrangement later in the created label document, you can.
7. In the Brand dropdown list, select Avery Letter Size if you're not using A4.
8. In the Type dropdown list, scroll through the billions of labels. Select the type of label you're using, 8160 Inkjet Address is a good one but just use whatever is on the envelope of labels.
9. This step and step 10 , and step 15, are optional but recommended. Click the Options tab.
10. Select the Synchronize Contents option IF you want to apply formatting, like a different font or colors or adding graphics, and make those changes apply to all of your labels.
11.Click the Setup button next to the printer display.
12. Select the printer you want to print to.
13. In the printer options (this will vary according to your operating system) specify the appropriate paper feed or tray. For now, select Manual Feed.
14. Click the New Document button at the bottom of the window. The labels will appear. This is how it's supposed to look. You won't see the data, you'll see the field names like first name. When you print, the correct data will appear.
15. OPTIONAL: IF YOU SELECTED THE SYNCHRONIZE CONTENTS CHECKBOX
If you need to make changes, like adding spaces, rearranging fields, or changing formatting, do so in the upper left label. Make the text an interesting font, or make it the size you need. You can also right-click on the border of the upper right label, choose Frame, go to the Border tab, and give it a background color.
Then click Synchronize to apply those changes to all labels.
16. Choose File > Print. A message will ask if you want to print a form letter. Click Yes.
17. If you want to print labels for only certain records, you can select them in the scrolling list of records. Select one, press Ctrl, select the next, and so on. Or you can select a range of records like 1-20.
18. If you want to just print all the labels, choose All.
19. When you're ready, just click OK. You'll be prompted again to choose your printer. Print normally.
Note: If you have any problems printing, check your printer setup using your operating system setup tools.
Note: You can save the label document and just go back to it again when you need to use it again.
The comments to this entry are closed.
Source: https://openoffice.blogs.com/openoffice/2006/07/mail_merge_labe.html
0 Response to "Open Office Continuous Mail Merge Labels"
Post a Comment