ADDING DATA TO THE LIST TABLE
Yes! You are absolutely right! The data in the Base added to the table list. But why capital letters? It was a surprise to you?
Is this the sort of info you were hoping for? I have just written this to my self after three days of grinding my teeth, and going more steps back than forwards, trying to set up labels from an address list. So the odd remark is to me 12 months hence.
This is an attempt to lay out the process of making labels when you hope you have a database already. Not creating a new one
- I was not able to get full synchronisation, all the data should have down loaded into the label form but it would not and so in the end I had to mark clicking the space on extreme left of the table and then 16 entries down shift clicking again, and printing out one sheet at a time. Not ideal but it worked.
So
First Bring up LIBREOFFICE
Click on Database.
In the four rectangles that come up choose forms But first you may have to choose between creating a new base or using an existing one. Use an existing one. Hopefully suggestions will come up and not blue filling. However if a suggestion comes up with all sorts of gobbledegook that meant nothing to me click on that i.e. Open. And hopefully it will allow you to Browse for the files.
The file is in MY DOCS. First screen and the file ADD list 3 [I think!] comes below all the folders. Its there so look for it. Double click and eventually you will see it and another file listed LH bot rectangle. of the Forms block.
Double click on that and you should get the address list in tabular form.
There is an EDIT button to make changes and a query as to whether you want to save them or not.
When you think your list is OK got to File> New> Labels. With luck your label will look OK .[ If not sort out the basic label if you can rememeber how you did it 12 months ago] It has three tabs at the top LABEL FORMAT & OPTION. Make sure options has synchronise ticked.
If the label is OK
Click on NEW DOCUMENT
[ I had to close many times and use new doc again, and again]
This brings up a page of labels with “instructions” in them. Plus a box with SYNCHRONISE in it. Tick this.
Look for ICON “DATA SOURCE” looks like two barrels offset with a curly arrow.
Click on this and hopefully a panel with the same sort of layout of data addresses that you first saw will arrive along the top of the screen/ page.
Now Choose the addresses you want to print out. If all is going well, but start hopefully, click on the top leftmost square. Extreme left of the TITLES and topmost of the empty squares [if there are none click I guess the topmost ID col] left of the ID column. This should mark all the data you want to use for your labels.
THEN, and this is the bit that no one seems to tell you about,
This has emboldened some more ICONS one of which is the one you want like like a new born baby wants it mother’s milk. It is the ICON DATA TO RECORDS.
Click on this and if you have clicked on Synchronise before you should see a sheet of labels that you have spent hours trying to sort out if you had not found this note!
Oh happy bunny. You can still, as I intimated at the top of this page be happy even if the program is being snotty and only doing a single page. If you know what to do all well and good but if like me you it was a year ago since you last did this job, forget searching the internet, well perhaps in 2013 or 13 or 15, (just found this help so maybe here would be a good start) but just mark the requisite number of data records you want to print out and press the magic button “Data to Records” Gloat over the new sheet of labels, press print and print them and then do the next sheet.
Then resist the overwhelming desire to scream and shout and come back to this page and make any relevant notes.
JWA
Oh… it is really very difficult… Me for the first time it was very difficult too! I understand you! How about this - http://lmgtfy.com/?q=youtube+openoffice+print+labels