Ask Your Question

I created table of addresses and now looking to print out labels or envelopes

asked 2018-12-24 21:32:54 +0200

GreenhornHere gravatar image

By my user name YOU guys know I have NO idea what I am even talking about . I was in need of creating database of addresses . I found this site ( I try excel - but my brain was not able to take all the info) and while reading the pdf. file with help here , I gave it go . Now I have created table ( with the help form Getting Started with Base - HOw To) with lots of addresses - (name of business,address,city,post code, name of person etc.) I was hoping that now I would be somehow able to send all these (or is there option to pick just some of them) addresses to a printer for label / envelope printing. Please IF anyone of you would have the patience to explain to me the VERY next step. Or I would be so happy to read VERY SIMPLE MANUAL .. it is hard to teach guy with no experience in this field. Thank you for your precious time

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-12-24 22:01:59 +0200

Ratslinger gravatar image


The best advice to give based on your comments is to refer to the LO manual. There are step-by-step instructions for both envelope and label printing. There are also many answered questions in this forum about each of those. You can search by entering label or envelope in the forum search bar where it states Search or ask your question. Upon entry it will then display previously asked questions on the subject.

For the referred to documentation see -> LibreOffice Writer Guide. Look in Chapter 14 - Mail Merge.

edit flag offensive delete link more


@GreenhornHere Don't know or care for videos. May be outdated. Yes labels are 'printed' from writer - doesn't mean the data originates from there. Please read the document pointed to in my answer.

The error you seem to have indicates Java may not be installed. In your question you state the database is created. Is the table in the database actually created & working?

Ratslinger gravatar imageRatslinger ( 2018-12-25 18:44:26 +0200 )edit

Ha you got me ..yes it is created (I can open it every time I click on the file on my desktop) ..but - & I am lost ..I was under the impression that after I will input data in the table (address,name etc) I would be able to just use the commands from FILE - NEW to LABELS and it will print the desired addresses on labels smoothly ...seems I am wrong again

GreenhornHere gravatar imageGreenhornHere ( 2018-12-25 21:34:50 +0200 )edit

@GreenhornHere Since you already have a working DB with the data, if you follow the steps in the pointed to 'Mail Merge' chapter you can print labels in very short order. Certainly less time than all the irrelevant comments being posted. It's a simple process.

Ratslinger gravatar imageRatslinger ( 2018-12-25 22:45:07 +0200 )edit

THAT IS WHAT DOES NOT WORK FOR ME YET ....and I think I do follow properly the instructions on the screen

GreenhornHere gravatar imageGreenhornHere ( 2018-12-26 08:48:44 +0200 )edit

when trying to do the labels for printing out

in Writer I do these steps 1/ File 2/ new 3/ labels 4/ ..labels window pop up I do
4a/ Database - I chose one of my files here ("sample work" - here I do have 4 entries with 5 columns - ID,Company name,Address,City,Postal code) 4b/ Table - here I can only pick the one I chose in the step before - "sample work" 4c/ Database field - here I pick what should be on the label and in what order 4d/ Brand - Avery A4 4e/ Type J8160 address 4f/ Format - sheet

Now I click NEW DOCUMENT - and Window in LO Writer pop up where there are several labels on sheet. On the labels here I do NOT see the actual names from the Table I have used - but only the commands fields <companyname>

<city> <postalcode>

... any idea ?

GreenhornHere gravatar imageGreenhornHere ( 2018-12-26 09:35:40 +0200 )edit

... any idea ? Yes, it is simply continuing with the instructions. #8 is to click 'New Document' but that seems to be where you stop. At the end of that paragraph it states to go to Page 13 - Printing. From the document:


1) Choose File > Print. The message shown in Figure 11 appears. Click Yes to print.

2) In the Mail Merge dialog (Figure 12), you can choose to print all records or selected records. To select records to be printed, use Ctrl+click to select individual records. To select a block of records, select the first record in the block, scroll to the last record in the block, and Shift+click on the last record.

3) Click OK to send the labels directly to the printer.

You just need to follow ALL the steps.

Ratslinger gravatar imageRatslinger ( 2018-12-26 16:30:26 +0200 )edit

NOW i KNOW why I was confused ... after the Writer creates THE sheet I do see only the commands and NOT the addresses from the file I used ... so I thought something is wrong and did NOT follow up as you say . The video I saw on youtube has immediately on the writer sheet all the addresses . THANK YOU VERY MUCH....and if you would give me hint of you paypal acc I will send you few $ for six pack . Very appreciate your patience - have a great day

GreenhornHere gravatar imageGreenhornHere ( 2018-12-26 20:17:25 +0200 )edit

@GreenhornHere If there is to be any donation, then do so for LibreOffice (main page - The Document Foundation). I as well as many other users of LO are here just to pass on our knowledge. It is not always easy but in the long run effective enough.

Also, as you have been helped, please help others to know the question has been answered by clicking on the ✔ in upper left area of answer which satisfied the question.

Ratslinger gravatar imageRatslinger ( 2018-12-26 20:22:55 +0200 )edit

answered 2018-12-25 14:21:12 +0200

GreenhornHere gravatar image

updated 2018-12-25 15:37:59 +0200

I am also looking for some youtube help ...and there is video from Kris Occhipinti from 2012...I notice in his video while doing"Mail Merge Wizard" he has 8 steps in THE window...I do have only the first 5. Could this be the problem??

Hello Ratslinger, thank you for your time.

I downloaded the LO Getting Started - page 299 has info that labels can be printed only from Writer - do i need to somehow transfer my table from base to writer ?

While going through you help line ..after page 4 Creating and registering an address data source...using the wizard in Writer source (spreadsheet only let me to pick the file I like to use - it is one sample table from LO Base Tables) and I am getting C:\Users\user\Desktop\sample work.odb SQL Status: HY000 C:/Users/user/Desktop/sample%20work.odb could not be loaded ... now I am really lost

edit flag offensive delete link more


@GreenhornHere This is not an answer. Please use add a comment or edit original question when posting additional information.

Ratslinger gravatar imageRatslinger ( 2018-12-25 18:41:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-24 21:32:54 +0200

Seen: 216 times

Last updated: Dec 25 '18