Category: Mail Merge

Merge a mailing list with a letter, label document as a new file or printed output.

To merge a mailing list with a letter or a label document and to save the merged document as a new file, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Mail Merge Wizard’. This will open the same dialog box as has been shown in the previous sections.
[the_ad id=”12355″]
[show_slider name=mail-merge-outputs]

[the_ad id=”12356″]

Now complete all the steps to reach the step 8. Here, we have some radio buttons. Select the ‘Save merged document’ radio button. This will display the ‘Save merged document’ area. Choose the appropriate option here and then click on ‘Save Documents’. This is how we can save the mail merge outputs as a new file.

Once saved, these documents can be used in different ways including getting a printed output.

Print mail merge outputs: letters, labels.

To print the mail merge outputs, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Mail Merge Wizard’. This will open the same dialog box as has been shown in the previous sections.

Now complete all the steps to reach the step 8. Here, we have some radio buttons. Select the ‘Print merged document’ radio button. This will display the ‘Print settings’ area. Choose the different printer settings and configurations here and then click on ‘Print Documents’. This is how we can print the mail merge outputs.

[the_ad id=”12397″]

Insert data fields in a mail merge main document (letter, address labels).

To insert data fields in mail merge, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Mail Merge Wizard’. This will open the same dialog box as has been shown in the previous sections.
[the_ad id=”12355″]
[show_slider name=mail-merge-insert-data-fields]
[the_ad id=”12356″]
Now complete step 1 and 2 and come to the step 3. Select a data file or a mailing list for usage in the mail merge as has been explained in the last section. In the ‘Insert Address Block’ area, in step 3, we have a checkbox for whether the document should contain an address block or not. Check this checkbox and then choose the appropriate address block format from the options given. You can click on ‘More’ to get additional formatting options.

This will open the ‘Select Address Block’ dialog box which lists the additional formats. Select the required format here and then click on ‘OK’ to return to the main dialog.

In step 3, we can choose which address block field should match to which column in the data file. For this, click on ‘Match Fields’. This will open the ‘Match Fields’ dialog box.

Here, as can be seen in the below given illustration, we can select which element of the address block will match to which column in the data field. Likehas been matched to ‘Title’ and has been matched to ‘First Name’ and so on. After completing the matching, click on ‘OK’ to return to the main menu.

After this, click on ‘Next’ to move to the next step, ‘Create salutation’. Here, a salutation can be inserted into the document. Create the appropriate salutation from the provided options. The ‘Match Fields’ option can be used to match the different fields and the appropriate address list field can be selected to identify a female recipient.

After making all the selections, click on ‘Next’ to complete the insertion of data fields into a mail merge.

[the_ad id=”12397″]

Open, prepare a document, as a main document for a mail merge.

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spread sheet.

To open or prepare a document as a main document for mail merge, click on ‘Tools’ from the main menu bar and from the resulting drop-down menu, click on ‘Mail Merge Wizard’. This will open the below shown dialog box.
[the_ad id=”12355″]
[show_slider name=mail-merge-preparation]
[the_ad id=”12356″]

In this dialog box, under step 1, we can select which document will be selected as the main document. We can select the current document to be used as the main document, or we can create a new document, or we can also select an already created document or a template. All these options have been provided in the dialog box in the form of different radio buttons. The appropriate radio button can be selected from here. After making the selection, click on ‘Next’. The chosen document will be set as the main document.

Select a mailing list, other data file, for use in a mail merge.

To select a mailing list or a data file for usage in mail merge, first of all we need to create the data file and then register this data file in LibreOffice.

To create a data file, we can simply input the required data in a list format in a Calc spread sheet. Though LibreOffice accepts data files in multiple formats, but for this illustration we are going to use a Calc spread sheet. Input all the required data in a Calc sheet as has been shown below and then save this sheet with an appropriate name.

Now open LibreOffice Calc and click on ‘File’ from the main menu bar. From the resulting drop-down, click on ‘Wizards’, and from the resulting sub-menu, click on ‘Address Data Source’. This will open the ‘Address Book Data Source Wizard’.

In this wizard, we have a list of 5 ‘Steps’ which need to be completed. In the first step, select the type of the external address book which is being used. We are using a spread sheet, so select ‘Other external data source’ and then click on ‘Next’.

In the second step, under ‘Connection Settings’, click on the ‘Settings’ button to open the ‘Data Source Properties’ dialog box. In this dialog box, in the ‘Database type’ drop-down list, select ‘Spreadsheet’ and then click on ‘Next’.

Then browse to the location of the spread sheet document which we had created and select the path for the same. Click on the ‘Test Connection’ button to test the connection. This gives a success message in case of the correct connection.

After this, click on ‘Finish’ to return to the ‘Address Book Data Source Wizard’.

Do not click on the ‘Field Assignment’ button and directly click on ‘Next’. In the last step, select the location and name for the data file and then click on ‘Finish’. This will register the data file in Writer.

After the data file has been registered, it can be selected for usage in mail merge. For this, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Mail Merge Wizard’. This will open the same dialog box as was shown in the last section.

Now complete step 1 and 2 and come to the step 3. Here, we have the option to select a data file from the list of different data files which have been registered. For this, click on ‘Select Different Address List’. This will open the ‘Select Address List’ dialog box.

This dialog shows the list of all the data files which have been registered to LibreOffice. Select the appropriate file from this list and click on ‘OK’. This is how we can select a mailing list or data file for usage in mail merge.

[the_ad id=”12397″]