Mail Merge

 Sometimes we need to create the same letter for many people separately based on their name, address, mobile number, and email ID. Suppose you have an urgent task to create notice for many employees. It is very hectic to type a notice or letter separately.

Don't worry.

We have a feature in LibreOffice Writer called Mail Merge." Mail merging is very interesting topic. You can create multiple copies of a letter by using the Mail Merge Tool.

Step 1:

From the LibreOffice Writer Menu bar, click on Tools and Click  Mail Merge Wizard.

2. Select the starting document type, i.e.

        i.            use the current document

When we create a letter or notice, it is created on a new page. If the current page is new, then select this option; otherwise, ignore it.

or

      ii.            Create a new document

This option can be used for creating letters. This tool provides a new page. Generally, this option is used.

or

    iii.            Start from existing document

In this option, if a file notice or letter is already created. Again want to use this letter. Select this option.

or

iv.            Start from the template

Step 2:

What type of document Do you want to create?

a. Letter

b. Email message (choose a or b)

Step 3:

Click on Address Block by clicking Select Different Address List. The Create Address List window will open. Create the database(company , collage student, customer database etc. Type the full name, address, contact no, state, and country. Do  at least 3 entries .

Step 4:

Personalize the letter by using a salutation. Ex. Hello, Dear Sir, Mr. Surname, To whom it may be a concert, etc.

Step 5:

      i.            Adjust layout Set the Address Bar position.

   ii.            Then write your letter.

After letter creation click Edit Individual Documents from the Mail Merge Toolbar.

Finally Multiple copies of the letter are created.

You can print hard copy to distribute among Employee or send email via email by using outlook.