Mail Merge in LibreOffice
Vložit
- čas přidán 4. 09. 2011
- In this tutorial we take a look at using LibreOffice to perform a "mail merge". Mail merge allows you to take data you store in a spreadsheet or database, such as the names an addresses of your contacts, and integrate them into a text document. This process is used frequently to create mailing labels, or to personalize letters for mass mailings. I tried to make the topic a little more interesting by turning it into a game of Madlibs. Though the format is a little different, the process is the same.
Thanks again for watching! - Jak na to + styl
I'm watching this for my tomorrow's I T exam 😁,thank you nice video, i appreciate you that you started this at long ago itself
And all this time I thought it was impossible to perform a mail merge with Libreoffice. Thanks for the great tutorial!
Thank you sir for such an excellent explanation
You are my hero! I am putting together herbarium specimen labels and this great bit of information just saved me countless hours. Thank you!
This tutorial is still actual. Thank you very much!
usually i dont like to comment on the videos but personally i like the way it has explained the concept in a very easy manner.thanks
Love the way you give a running commentary on each step as you are doing. It makes it so much easier to understand what is happening and what is going on.
If you are not already a school teacher, you should think about changing careers -- assuming of course, you like lots of aggro and frustration.
Thank you so much. It's really helpful for me as i was having a hard time trying to mail merge my documents. Thanks a lot!
Thank you for this very direct and simple instruction...VERY HELPFUL...thank you again!
Thanks for putting this together. It is exactly what I needed to get my project started.
Amazing Sir...👌👌
Great video! Very helpful.
Awesome this tutorial have save my life! Usually I don't work with libreoffice but this the only option available in my job. And as developer the manager ask me how to generate like a thousand of letters, thanks to this tutorial i did it in 10 minutes.
Please can you tell how to Insert the 'Person' in document? .....
A very nice tutorial. Thank you
love the madlibs!
Nice demo. Thanks.
thank you sooooo much ! Very clearly explained and so helpfull. Very easy and a lot of time saved !
Excellent explanation Thanks Tony
Thanks a lot!! Excellent tutorial!
Excellent tutorial, thanks :-)
Thanks. Great walk through.
it was very helpful. thanks!!!
That was an excellent lesson.
way better explanation than my teacher! thanks!
Thank you so much sir. You have made my life much easier. I don't usually comment. But this video has helped me so much with my direct mail campaigns and saved me hundreds of dollars. Thanks! I can now print my own postcards BOOM
Very helpful and appreciated.
Thank you for showing us how this is done.
Thankyou it was really helpful :D
Very helpful
thank you, that was really helpfull
Muy bueno el video. Gracias.
Awesome video bro
Agree, very helpful, thanks!
Dis is good dawg..
Thank u very much!
Very nice, explains the concept of mail merge thorougly!
BTW - there is a shortcut to creating a mail merge document, Tools -> Mail Merge Wizard...
Thanks man
thank you tony :)
i just started using LibreOffice 2 days ago.
this tutorial really helped a lot.
i was thinking of using mail merge to create individual certificates.
is there a way to add a new step (after doing the mail merge and exporting as pdf)
- to email the individual pdf do their respective owners (email addresses provided per record)?
thanks.
Excellent tutorial!
What do you do if 1 of your fields is an image, such as a photo or a logo?
Yo!! Thank you soooo much bro! U save my life.. Aw😅
Thanks :)
what about opening an existing MS Word mail merge document with Libre office? Doesn't seem to work and I don't want to have to re-create every merge that I've ever created with word. Also, is there a limit to the number of merge fields with Libre like there is with Word? It would be awesome to create mail merge with 100+ fields and "if/then" capability
@linktwo Thanks!
Connecting to a database server is pretty much the same as using a spreadsheet. When you create a new database using LibreOffice Base, instead of selecting "Connect to an existing database" and choosing "Spreadsheet", you would select the option that applies to your database such as "JDBC", "ODBC", or "MySQL". You will then also have to enter the url of the database and your login credentials (username, and password).
HELP! I'm all the way through, but when I get to the print stage, the Mail Merge dialogue box doesn't come up to complete the final merge before saving/printing to a PDF.
Thank you. This video is concise and simply laid out.
I recently ran into a problem that others may have encountered:
Trying to consolidate a plethora of contract and invoice templates, I discovered that if I moved any source document (.odb or .ods) out of it's original folder, the templates wouldn't locate them. I can move the templates without issue.
If anyone knows how to reassign the location of a database and it's corresponding spreadsheet without having to reassign all data fields in my templates, please let me know.
thanks a lot
Thanks
I reached till adding fields and when i click on the desired word to be replaced with a field, it is not working. The field in the database is not showing in the doc. Pl advice.
make sure that your table starts from the first row and first column, even i had the same problem this worked for me.
Thank you
Great Video very helpful - I now need one to show how to mail merge onto Labels (3 labels wide - Avery 8160)
thanks
Can we store & show images in libreoffice Mail merge ?
@cpguru21 I haven't tried this on a data set with 1000 records. Even if your document is only 1 page, you will end up with a 1000 page document. I will likely take a while to generate all that, but I'm sure its faster than doing it manually. If you are having trouble, I would recommend breaking up your data set in to smaller chunks. Perhaps you can try 250 records at a time.
Please can you tell how to Insert the 'Person' in document? .....
This is very descriptive one. Thanks !!!
But I would like to learn doing same thing without using BASE too.
still relevant
THANK YOU! I've been suffering for 4 hours because of this stupid merge in LibreOffice >:(
merci
Hi Mr. Pelaez,
I realize that this video is from quite a while back, but I am hoping that you may still receive information about comments to it from time to time.
This is really a great video. It shows off the potential for so much more than mere address labels when working with the "mail merge" feature of LibreOffice. Catalogs, inventories, notebooks, and all kinds of publications can be potentially created with the features that you have shown here.
I have two questions:
1) Is there an "end record" or "next record" field or field code that can be entered into Writer to get Base to provide more than
one record per page in Writer? If so, how do you do it?
2) Is there any known way to do a "mail merge" with LibreOffice Draw and have it provide more than one record per page?
If so, how do you do it?
Thank you for your help in this matter.
All the best,
Shawn
Thank you. But didn't get that you dragged the header of the column and it confused me. But got it now.
Hey nice video but how do you use mail merge to send emails to customers etc i dont use outlook will it work using libre?? I will be even happier if you reply or make a video on this. Thanks as im fed up with microsoft
Hi, great tutorial! I am using LibreOffice 5. I got to 6:40 seconds without problems but clicking on the header does not work for me. The contents in the writer document are not being replaced by te contents from the database. (th)e actions from 6:40 do not work,) I have a second question. Your 'final product' is a report with 1 record per page but considering there's plenty of empy space how can I print 2 records per page? Tanks! Greeting from Brazil
P.S - I figured out was i was doing wrong. it works fine. However if you could pls answer my second question I´d appreciate. Tks
I'm glad you got it figured out. In answer to your second question, as far as I know, a single record will only result in one document. There are some things you can try however to accomplish what you ask:
If it is a matter of printing less paper you may be able to reduce the document size by half, creating the merge, and then changing your printer settings so that two pages are printed on one. Your ability to do that will largely depend on the features offered by your printer driver.
The second option you can try is to transform the data so that you are displaying two records per row (essentially doubling the number of columns). For example, if your data is a single field called "Name1", you can divide your data in half and copy it into a second field called Name2. You will then have to create your template so that it will show Name1 on the top half and Name2 on the bottom half.
@@marcelobonimani What did you do to make it work? I have the same problem.
This is a great tutorial. How will LibreOffice handle a data set of around a thousand lines or so? 3 lines are easy, but not realistic. Does anyone have experience with a large data set?
Thanks!
Mail Merge can be done by just using Writer and Calc. No need of base. Complicated explanation.
plz say how to make poster in libre office & make a video
I'm not that is possible. LibreOffice does not have an Outlook replacement. There are better solutions out there in my opinion, and if you are on Linux you could even script your own using sendmail and bash. You may also want to look in to a service that will do this for you such as mailchimp.
Thanks sexy
thanks