On Tue March 14 2006 19:55, + Alan Armstrong wrote: > Open Office v 2.0.2 > My database has over 400 records and I select them all yet I can only > print page 1 when following text in Printing Address Labels in Help. What > am I doing wrong?
Hi Alan, As you are not subscribed you may not have seen that: On Tue March 14 2006 23:59, Keith Bates wrote: > > Following problems that I and others had in printing Christmas labels, > I posted the following "definitive guide" on this list. Note especiall > point 2. > > You might also like to peruse the "Getting Started Guides" at > > http://oooauthors.org/en/authors/userguide2/published/copy_of_index_html > > > 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. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
