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]
