How do I print labels from a spreadsheet i.e database

Hi,
A asume you use base for your mail-adresses.
Now, open OpenOffice, goto File > New > Labels.
Select the database, the table, and the first field you want to add to your label. Click the arrow pointing left.
Repeat the field-select-steps until you have all the fields you need.

Select Brand and Type of the labels.
Check the format of your labels (next tab)
Click "New Document"
Now you get a bit of a silly page, full of labels wich do not make sense, and a button with Synchronize labels.
You can edit the first label to your needs, then press the Synchronize labels button.

Choose View > Data Source {F4}
Select the records you want a label from, by clicking the row-headers to the left. Use CTRL or Shift to select multiple records.

Now click the Data to Fields Icon. It is on the Table-Data Toolbar.

Succes

I have tried to do this but when I get to database, it's like a toggle switch, I keep going back and forth, it doesn't seem to want to pick up my database. Then when I type in all the info and press Synchronized label button, there is no Sata Source under View I can't even get this far.

Might be this helps http://openoffice.blogs.com/openoffice/2006/07/mail_merge_labe.html

Hth