Here is how to do it, combining wisdom from Jean Hollis-Webber and others. 1. The first step is to create your address data base.
If starting from scratch go to File- New- Database and use the wizard to create a database and new table. If using a pre-existing table, then in Writer, go to File > Wizards > Address Data Source. On the first page of the wizard, choose "Other external data source" and click Next. Then follow the prompts. 2. Next create your labels. You must note that if your labels will cover more than one page there is a bug which requires a work around. The following assumes that you are printing more than one page. 3. Go to File- New- Labels. Set up the labels the way you want them to be, following the help file if necessary. On the Database" section on the main "Labels" tab (that's the part you see when the dialog opens) choose the relevant database and table, then the fields that you want to see on your labels. When you are happy with the layout, click on the Options tab and make sure "Synchronize contents" is selected. 4. Click "New Document" 5. At this stage it gets tricky, because there is conflicting advice. Some people say you have to add an additional field to tell OO that you don't want all the labels the same. I found that if you do this it actually skips every second record. So, if after the next few steps you find all the labels are the same you must go Insert- Field- Other then click on the Database tab then "Next Record"- Insert- Close. After that click on the Synchronize Labels button. 6. Press F4 to get the data source. Select your table. 7. Select the records you want to print in the table view. You can use Shift and Control to select multiple records. 8. Click on the "Data to Fields" button- it is a small green square with two horizontal lines above and below. It will take a while to populate your labels with your data. Are the labels the ones you actually want? If not go back to 5. 9. Now it is time to print your labels. Go File- Print. It will ask you if you want to print a form letter. Select "Yes". Then in the subsequent dialog select the records you want printed. Select single print job, then OK and it should print. Hope this helps others at this busy time of year. -- God bless you, Keith Bates 4 Mooloobar St Narrabri NSW 2390 Phone: 02 67924890 Fax: 02 67925418 www.new-life.org.au If you don't have a reason to live JESUS IS THE ANSWER! Ask him into your life today... He really does make a difference. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]