Mark: Here is a process that works for me: 1. File > New > Labels 2. On the Labels tab, choose label Brand (e.g. Avery Letter Size) and Type (e.g. 5260 Address). 3. Still on the Labels tab, select the Database, select its Table, and select Database field names one at a time and move to the left using the left-pointing arrow. Insert line breaks, spaces, commas, etc. as needed. 4. Go to the Options tab and turn OFF Synchronize Contents. 5. Click New Doc. 6. Select File > Print. Answer Yes to the question that asks if you want to print a form letter. (OK, I know you're not printing a form letter, you're printing labels; but answer Yes anyway.) 7. Select records that you want printed, or click "All". 8. Click OK.
Have you tried those steps? In particular, when you go File > Print, do you get the dialog that asks if you want to print a form letter? That's the part of the above process where the field names are replaced by the data in the fields. If you don't see that dialog, that is probably the problem. Unfortunately, I don't know of a ready solution. There's a checkbox on that dialog that says something like "Do not show this warning again." There is a report that if you EVER check that box, you are NEVER presented with this dialog again. I've been afraid to try to verify that for myself! Dick, Webster, NY In a message dated 12/22/2005 5:32:55 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Peter, I cannot find a button or check box called "Data to Fields". The closest I found is under options on the label dialog that says "Synchronize" I checked that and still no data in the labels, just fields. Thanks, Mark On Thursday 22 December 2005 01:55 am, Peter Hillier-Brook wrote: > >>>I set up a mysql database with address information. I want to create > >>> some mailing labels. However, every time I set them up, all I get is > >>> the database fields in the labels and not the data. (Openoffice 2.0 on > >>> Linux). > >>> > >>>This is what I did: > >>>1. Created two tables in a mysql database - one with the names/addresses > >>>and one with the dates I have mailed to them. These two tables are > >>> linked by a name_id field. > >>> > >>>2. In Base I created a query that selects the data from the names table > >>>based on a criteria in the other table. I tested the query and it works > >>>in the design view. Something like - SELECT * FROM Names, Sent WHERE > >>>Names.name_id=Sent.name_id AND Sent.year=2005 > >>> > >>>3. I selected new from the file menu and then labels. > >>> > >>>4. I selected the database, table, and fields for the label, then > >>> selected new document. > >>> > >>>All I get in the labels are the names of the fields and not the data > >>> from the table. > >>> > >>>Any suggestions would be greatly appreciated. > > You don't appear to have selected "Data to Fields" This is the command > that populates your document! > > Peter HB > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
