Tutorial How to Make a Mail Merge on LibreOffice

in #utopian-io7 years ago (edited)

cara-upgrade-libre-office.png

What Will I Learn?

  • How to use Base Database LibreOffice
  • How to make A Mail Merge
  • How to use Writer Libreoffice

Requirements

Requirements
System Requirements
No special requirements.

OS Support
Microsoft Windows (IA-32 and x86-64), Linux (IA-32 and x86-64) and macOS (x86-64).

Requirements
Program Install Support: Install and Uninstall

Difficulty
Intermediate

Information

Website & Download: https://www.libreoffice.org/

Type : Office suite software

License : The LibreOffice project uses a dual LGPLv3 (or later) / MPL 2.0 license

Operating System : Linux, OS X, Microsoft Windows, Solaris

Platform : IA-32, x86-64, PowerPC, SPARC

for more information here

Difficulty

  • Intermediate

Tutorial Contents

Mail Merge is a useful tool that allows you to generate multiple letters, labels, envelopes, name tags, and more using information stored in lists, databases, or spreadsheets. When utilizing Merge Mail, you need a Word document (you can start with an existing one or create a new one) and a list of recipients, which is usually an Excel workbook.
Source

And now i will teach libreoffice users how to create a good and correct mail merge. follow these steps to the end.

  • first, you should open the libreoffice application and select the base database to create a data or open a data you have created before.
    1.png
    for example create a new data making it easier for users to start from first.
    2.png
    klik next and save
    3.png
    and i use merge mail name
    4.png

  • second, you click create in design view to create a data you want.
    5.png
    and fill in the available tables with names, addresses, and more. so as in the example below
    6.png
    then change the entry required to yes, to make it easier for us to fill in the next table and then save the data.
    7.png
    8.png

  • thirdly, you should go back to the base database menu and fill in the table you created before. and save the data.
    12.png

  • fourth, after you finish fill the data and save the data, you should open the Writer aplication to do merge mail.
    9.png

  • fifth, when the Writer application has opened you directly click on the view button and select the data source or you can press the CTRL + SHIFT + F4 key on your keyboard to open directly the data you have created.
    10.png
    then select the data you have saved before
    11.png
    so out the data you have created
    13.png

  • sixth, then you have to create a worksheet according to what you want to fill, the example I have done is below:
    14.png

  • seventh, then drag the NoID you have created earlier and place it according to the worksheet you created
    15.png
    and do the same on the next data and fill in your worksheet16.png

  • eighth, if you have filled your worksheet with the data you have written, then you should save it so you can see the result, which will automatically display the data you have created into your worksheet which already contains the name, NoID, etc.

how to save the data is to use the print menu on the toolbar file,
17.png
then you change the output from print command to file then choose save in PDF form
18.png

  • Lastly, open the file that you have saved and which contains the merge mail that you created earlier. and the results are as follows:
    las.png
    last.png
    it will automatically fill in the form you have created with the data you have created as well

Curriculum

This is my second tutorial

Sort:  

Your contribution cannot be approved because it does not follow the Utopian Rules.

Hey @redart, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!