View source for Documentation/OOoAuthors User Manual/Writer Guide/Using Mail Merge

{{NeedsWork}}
This page was created by converting ODT to Mediawiki using Writer2MediaWiki.

This is Chapter '''11''' of the '''OpenOffice.org 2.x Writer Guide''' (Third edition), produced by the [http://oooauthors.org/ OOoAuthors group]. A PDF of this chapter is available from the [http://documentation.openoffice.org/manuals/oooauthors2/ OOoAuthors Guides page] at OpenOffice.org.

[[User_Manuals| &lt;&lt; User Manuals page]]<br>
[[Writer Guide| &lt;&lt; Writer Guide Table of Contents]]<br>
[[Writer Guide/Working with Templates| &lt;&lt; Chapter 10 Working with Templates]] &nbsp;&nbsp;|
&nbsp;&nbsp;[[Writer Guide/Creating Tables of Contents, Indexes, and Bibliographies| Chapter 12 Creating Tables of Contents, Indexes, and Bibliographies &gt;&gt;]]


= What is mail merge? =
OpenOffice.org (OOo) Writer provides a very useful feature to:

* Create and print multiple copies of a document to send to a list of different recipients (form letters).
* Create and print mailing labels.
* Create and print envelopes.

This chapter describes the entire process. The steps include:

# How to create and register a data source.
# How to create and print form letters, mailing labels, and envelopes.
# Optionally, how to save the output in an editable file as an alternative to printing it directly.

= Creating the data source =
Although you can create and print mailing labels and envelopes without using a data source, in most cases using a data source is the most expedient approach. This chapter assumes that you are using a data source.

A data source is a file, spreadsheet or database, which contains the list of names and addresses the letter is to be sent to.

For this example, we will use the following column headers: ''First name, Last name, Address 1, Address 2, Town/City, State/County, Country, Postal Code, Gender, Points''. A sample data source is shown below.

OOo can access a wide variety of data sources, including spreadsheets, text files and databases such as MySQL, Adabas, and ODBC. If the information to be used in the mail merge is currently in a format that OOo can not access directly, you need to convert it, for example by exporting it to a comma-separated file.

You can enter the data for the mail merge as part of the Mail Merge Wizard. However, if you have more than a few records, you probably should use an external data source. 

[[Image:WG11-1.png|Spreadsheet data source]]<br>Spreadsheet data source.

= Registering a data source =
Before any OOo documents can use a data source, it must be registered.

To register a data source:
<ol>
<li>Click '''File > Wizards > Address Data Source'''.</li>

[[Image:WG11-2.png|Starting the Address Data Source wizard]]<br>Starting the Address Data Source wizard.

<li>Select the appropriate type of data book (in this case, '''Other external data source'''). Click '''Next'''.</li>

[[Image:WG11-3.png|Select type of external address book]]<br>Select type of external address book.

<li>On the next page of the Wizard (Figure 4), click '''Settings'''.</li>

[[Image:WG11-4.png|Starting the Settings part of the Wizard]]<br>Starting the Settings part of the Wizard.

<li>On the Data Source Properties dialog, select the Database type (in this case, '''Spreadsheet'''). Click '''Next'''.</li>

[[Image:WG11-5.png|Selecting the database type]]<br>Selecting the database type.

<li>On the next dialog, click '''Browse''' and navigate to the spreadsheet that contains the address information. Select the spreadsheet and click '''Open''' to return to this dialog.</li>

[[Image:WG11-6.png|Selecting the spreadsheet document]]<br>Selecting the spreadsheet document.

<li>Click '''Finish'''.</li> 

<li>On the following dialog, click '''Next'''. (Do not click '''Field Assignment'''.)</li>

[[Image:WG11-7.png|Do not click Field Assignment]]<br>Because this is a spreadsheet, do '''not''' click Field Assignment.

<li>Name the file in the location field. The default will be '''...\Addresses.odb'''; you can replace '''Addresses''' with another name if you wish. You can also change the name in the '''Address book name''' field. In our example, the name "Points" was used for both.</li>

[[Image:WG11-8.png|Name the file and the address book]]<br>Name the .odb file and the address book.

<li>Click '''Finish'''. The data source is now registered.</li>
</ol>

= Creating a form letter =
'''Example: Sending a letter to your customer base'''<br>
A mail order company organized a campaign to assign credit points to their customers according to the quantity of goods they buy during one year. At the end of the year, they want to send a letter to each customer to show the total of credit points collected.

You can use the Mail Merge wizard to create a form letter, or you can create the letter manually. See [[#Using the Mail Merge Wizard to create a form letter|Using the Mail Merge Wizard to create a form letter]] for instructions on using the Wizard.

This section describes how to create a form letter manually.
<ol>
<li>Create a new text document: '''File > New > Text Document'''.</li>
<li>Display the registered data sources: '''View > Data sources''' (or press '''F4''').</li>
<li>Find the data source that you wish to use for the form letter, in this case '''Points'''. Expand the '''Points''' folder, expand the '''Tables''' folder, and select '''Sheet1'''. The data file is displayed.</li>

[[Image:WG11-9.png|Selecting the data source]]<br>Selecting the data source.

<li>Now create the form letter by typing in text, punctuation, line breaks, and so on that will be present in all of the letters, and adding fields where needed by clicking in the field heading and dragging to the appropriate point in the letter.</li>

[[Image:WG11-10.png|Dragging fields]]<br>Dragging fields to the body of the form letter.

<li>Continue until you have composed the entire document. (See below for an example.)</li>

[[Image:WG11-11.png|Completed form letter]]<br>The completed form letter.

<li>The document is now ready to be printed. Click '''File > Print'''.</li>
<li>The following dialog appears. Answer '''Yes'''. Do not select the checkbox.</li>

[[Image:WG11-msg.png]]

<li>In the Mail Merge dialog, you can choose to print all records or selected records. To select records to be printed, use ''Ctrl+click'' to select non-contiguous records. To select a contiguous 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.</li>

[[Image:WG11-12.png|Mail Merge dialog]]<br>The Mail Merge dialog.

<li>Click '''OK''' to send the letters direct to the printer. If you wish to check the letters before printing, see [[#Saving as a file rather than printing|Saving as a file rather than printing]] for instructions.</li>
</ol>

= Printing mailing labels =
Before beginning this process, check to see what brand and type of labels you have. 

To print mailing labels:
<ol>
<li>Click '''File > New > Labels'''.</li>
<li>On the Labels dialog, go to the '''Options''' tab and uncheck '''Synchronize contents''' if it is checked.</li>

[[Image:WG11-13.png|Uncheck Synchronize contents]]<br>Uncheck Synchronize contents.

'''Note:''' If you need to suppress blank lines in some of your labels, read [[#Removing blank lines in labels|Removing blank lines in labels]].

<li>On the '''Labels''' tab, select the '''Database''' and '''Table'''. Select the '''Brand''' of labels to be used, and then select the '''Type''' of label.</li>

[[Image:WG11-14.png|Select Database, Table, label Brand, and label Type]]<br>Select Database, Table, label Brand, and label Type.

<li>Click the dropdown arrow under '''Database field. '''Select the first field to be used in the label (in this example,''' First name'''). Click the left arrow button to move this field to the '''Label text''' area.</li>

[[Image:WG11-15.png|Move fields from Database field list to Label text area]]<br>Move fields from Database field list to Label text area.

<li>Continue adding fields and inserting desired punctuation, spaces, and line breaks until the label is composed. The figure below shows the completed label.</li>

[[Image:WG11-16.png|Completed label]]<br>The completed label.

<li>Click '''New Document'''.</li>
<li>Click '''File > Print'''. The following dialog appears. Click '''Yes'''. Do not select the checkbox.</li>

[[Image:WG11-msg.png]]

<li>In the Mail Merge dialog, you can choose to print all records or selected records. To select records to be printed, use ''Ctrl+click'' to select non-contiguous records. To select a contiguous 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.</li>

[[Image:WG11-12.png|Mail Merge dialog]]<br>Mail Merge dialog.

<li>Click '''OK''' to send the letters direct to the printer. If you wish to check the labels before printing, see [[#Saving as a file rather than printing|Saving as a file rather than printing]] for instructions.</li>
</ol>

= Printing envelopes =
Instead of printing mailing labels, you may wish to printing directly onto envelopes. Printing envelopes involves two steps: setup and printing.

== Setting up envelopes for printing ==
To set up envelopes to be printed with your letters:
<ol>
<li>Click '''Insert > Envelope''' from the menu bar.</li>
<li>In the Envelope dialog box, start with the '''Envelope''' tab (shown below). Verify, add, or edit the information in the Addressee and Sender boxes (Sender is the “from” on the envelope). You can use the right-hand dropdown lists to select the database or table from which you can draw the envelope information. Use the same method as described in [[#Creating a form letter|Creating a form letter]].</li>

[[Image:WG11-18.png|Choosing addressee and senderinformation]]<br>Choosing addressee and sender information for envelopes.

<li>On the '''Format''' tab, verify or edit the positioning of the addressee and the sender information. The preview area on the lower right shows the effect of your positioning choices. To format the text of these blocks, click the '''Edit''' buttons to the right.</li>

* In ''Character'', you can choose fonts, sizes, underlines or color, rotating/scaling, backgrounds and more. 
* In ''Paragraph'', you can choose indenting, alignment, flow, tabs and more.

[[Image:WG11-19.png|Choosing positioning and size of elements]]<br>Choosing positioning and size of elements for an envelope.

<li>In the lower left of this tab, choose the envelope format from the dropdown list. The width and height of the selected envelope then show in the boxes below the selected format. If you chose a pre-existing format, just verify these sizes. If you chose ''User defined'' in the Format list, edit the sizes.</li>
<li>After formatting, select the '''Printer''' tab to choose printer options such as envelope orientation and shifting. You may need to experiment a bit to see what works best for your printer. You can also choose a different printer or alter the printer setup (for example, specify the tray that holds envelopes) for this print job.</li>

[[Image:WG11-20.png|Choosing printer options]]<br>Choosing printer options for an envelope.

<li>When you have finished formatting, click either the '''New Doc''' or '''Insert''' button to finish. '''New Doc''' makes only the envelopes or starts a new document with the envelopes. '''Insert''' inserts the envelopes into your existing document as page 1.<br/> To not proceed with this envelope, click '''Cancel''' or press the ''Esc'' key. You can also click '''Reset''' to remove your changes and return to the original settings when the dialog box opened.</li>
<li>To remove blank lines from the addresses, use the technique described in steps 1 through 5 in [[#Removing blank lines in addresses|Removing blank lines in addresses]].</li>
</ol>

== Merging and printing the envelopes ==
To merge addresses and print the envelopes:
<ol>
<li>Choose '''File > Print'''. The following dialog appears. Click '''Yes'''. Do not select the checkbox.</li>

[[Image:WG11-msg.png|Confirmation dialog]]<br>Confirmation dialog for merging database fields.

<li>The Mail Merge dialog appears. As with form letters and mailing labels, you can choose to print envelopes for one, several or all address records in the database.</li>

[[Image:WG11-22.png|Choosing records]]<br>Choosing records to use when printing envelopes.

<li>Make your selections and then click '''OK''' to print direct to the printer. If you wish to check the envelopes before printing them, see [[#Saving as a file rather than printing|Saving as a file rather than printing]] for instructions.</li>
</ol>

= Using the Mail Merge Wizard to create a form letter =
To start the Mail Merge wizard, select '''Tools > Mail Merge Wizard'''. The wizard opens, as shown below.

== Step 1: Select starting document  ==
The wizard gives various options to select your starting document:

* Use the current document.
* Create a new document.
* Use a template.
* Use an existing document.

You can write the letter later on in the wizard, but it is easier to use a draft you prepared earlier. For this example, select '''Use the current document''' and click '''Next'''. 

[[Image:WG11-23.png|Select starting document]]<br>Select starting document.

== Step 2: Select document type ==
The wizard can produce letters or, if a Java Mail connection exists, email messages. You can see these options in the figure below. In this example, we are producing a letter. Select '''Letter''' and click '''Next'''.

[[Image:WG11-24.png|Choose document type]]<br>Choose document type.

== Step 3: Insert address block ==
This is the most complex step in the wizard. In this step you will do three things:

# Tell the wizard which data source to use. The data source must be a file; in this example it is the spreadsheet created earlier. 
# Select the address block to use in the document. This means choosing which fields appear (for example, whether the country is included) and how they look. 
# Make sure that the fields all match correctly. This is very important. For example, the wizard has a field called &lt;Last Name&gt;. If your spreadsheet has a column called "Surname", you need to tell the wizard that <Last Name> and “Surname” are the same thing. This is described in [[#Matching the fields|Matching the fields]].

: [[Image:WG11-25.png|Insert address block]]<br>Insert address block.

=== Selecting the data source (address list) ===
# Click '''Select Address List '''in section 1. This opens the Select Address List dialog for choosing a data source. 
# If you have not already created the address list, click '''Create''' to do so now. If you have an address list, as we have in this example, click '''Add''' and select the file.
# Select the spreadsheet file and click '''OK''' to return to step 3 of the wizard. For this example, the preceding steps are all you need to do. The wizard can also exclude certain records; click '''Filter''' to choose them. 

: [[Image:WG11-26.png|Select address list dialog]]<br>Select address list dialog.

=== Selecting the address block ===
<ol>
<li>In step 3 of the wizard (shown in [[#Step 3: Insert address block|Step 3: Insert address block]]), look at section 2. This is where you select the address block to appear on the letter, and define its appearance and the fields it contains. The main page gives two examples. If neither of those is exactly what you want, click '''More''' to see more choices, in the Select Address Block dialog box (shown below).</li>

[[Image:WG11-27.png|Select address block]]<br>Select address block.

<li>The Select Address Block dialog box offers six choices for the format of the addresss block (scroll down to see the last two choices). You can also optionally include or exclude the country (for example, only include the country if it is not USA). The six formats provided are relatively common, but they might not exactly match your preference. If this is the case, select the address block that is closest to what you want and click '''Edit''', which opens the New Address Block dialog box.</li> 

[[Image:WG11-28.png|New address block]]<br>New address block.

<li>In the New Address Block dialog, you can add or delete address elements using the arrow buttons on the left. To move elements around, use the arrow buttons on the right. For example, to add an extra space between first and last names, click <Last Name> and then click the right arrow button.</li>
</ol>

=== Matching the fields ===
Finally, it is time to match the wizard’s fields with the spreadsheet fields, so that items like <Last Name> and “Surname” match correctly.
<ol>
<li>Look at section 3 of step 3 of the wizard. The box at the bottom displays one record at a time, using the address block format you selected. Use the right and left arrow buttons below that address box to step through the addresses, checking that they display correctly. Do not assume that all the records display correctly, just because one or two do. Check them all if you can, or at least a good proportion.</li> 
<li>If the addresses do not display correctly (and they probably will not right away), click '''Match Fields'''. The Match Fields dialog box opens.</li>

[[Image:WG11-29.png|Match fields dialog box]]<br>Match fields dialog box.

The Match Fields dialog box has three columns.
<ul>
<li>''Address Elements'' are the terms the wizard uses for each field, such as <First Name> and <Last Name>.</li>
<li>The ''Matches to Field'' column allows you to select, for each address element, the field from your data source that matches it.</li>
<li>The ''Preview ''column shows what will be shown for this field from the selected address block, so you can double-check that the match is correct.</li>
</ul>
<li>When you have matched all the fields, click '''OK''' to return to step 3 of the wizard. Now, when you use the arrow buttons to look at all the addresses, they should all look correct. If not, go back and change anything you’re not happy with, before clicking '''Next''' to move to step 4.</li>
</ol>

== Step 4: Create salutation ==
The salutation is the initial greeting, for example, ''Dear Mr Jones'''. '''''In step 4, select the salutation that will appear in the letter.

[[Image:WG11-30.png|Create a salutation]]<br>Create a salutation.

You can use a different greeting for men and women. To do this, Writer must have some way of knowing whether a person is male or female. In our spreadsheet we had a column called ''Gender''. In the section '''Address list field indicating a female recipient''', set the field name to ''Gender'' and the field value to ''F''. The male salutation is then printed for all men and the female salutation for all women. 

'''Note:''' You do not need to tell OOo who is a male, because it assumes that all non-female records are males.

If you do not select '''Insert Personalized Salutation''', you can use a more general salutation without referring to the recipient directly, such as “To whom it may concern”.

As in step 3, step 4 of the wizard has a preview pane at the bottom. You should check more than one record to ensure that other records look the way you expect.

== Step 5: Adjust layout ==
In step 5, you can adjust the position of the address block and salutation on the page. You can place the address block anywhere on the page. The salutation is always on the left, but you can move it up and down the page. Use the buttons shown in the figure below to move the elements.

[[Image:WG11-31.png|Adjust layout]]<br>Adjust layout.

== Step 6: Edit document and insert extra fields ==
In step 6 you have another opportunity to exclude particular recipients from the mail merge, as shown below.

[[Image:WG11-32.png|Edit document]]<br>Edit document.

You can also edit the body of the document. If you started with a blank document, you can write the whole letter in this step. Click '''Edit Document '''to shrink the wizard to a small window so you can easily edit the letter.

[[Image:WG11-33.png|Minimized mail merge wizard]]<br>Minimized mail merge wizard.

You need to perform another important task in this step. The wizard only inserts information from the name and address fields, but you may wish to add additional data. In our example, we want to tell each person how many points they had accumulated during the year; that information is in the spreadsheet. 

To do this:
<ol>
<li>Click '''Edit Document''' in step 6 of the wizard.</li>
<li>Select '''Insert > Fields > Other'''. The Fields dialog box opens, as shown below.</li>

[[Image:WG11-34.png|Insert mail merge fields dialog box]]<br>Insert mail merge fields dialog box.

<li>Click the '''Database '''tab.</li>
<li>On the left hand side, select '''Mail merge fields'''.</li>
<li>Under '''Database selection''' find your data source (in this example, it is a spreadsheet). Expand it to see the fields.</li>
<li>Click the field you want to insert, then click '''Insert''' to insert the field. You can insert any number of fields any number of times into your mail merge document.</li>
<li>Click '''Close''' when you are done.</li>
</ol>

'''Note:''' The '''Database selection''' lists the data source you selected in step 3. All the information you need for the letter must be contained in that data source.

== Step 7: Personalize documents ==
In step 7, OOo creates all your letters, one per recipient.

Clicking the '''Edit Document '''button here is similar to step 6. The difference is that you now edit a long file containing all of the letters, so you can make changes to a particular letter to one person. In step 7 of the Mail Merge wizard, click '''Find''' to open a dialog box that allows searches within the document.

[[Image:WG11-35.png|Personalize document]]<br>Personalize document.

As with step 6, when editing the document, the wizard shrinks to small window. Click on this window to expand the wizard to its full size.

== Step 8: Save, print or send ==
You have now completed the mail merge process. The last step is to do something with it. In step 8, you can save the original sample letter, save the merged document, print the letters right away or, if you created email messages, send them.

[[Image:WG11-36.png|Save, print or send]]<br>Save, print or send.

You probably want to save the starting document and the merged document. The merged document can be saved as one big file or one file for each letter.

When you have saved the merged document, you can print the final letters now or later; and you can still manually check and edit the letters if necessary.

= Saving as a file rather than printing =
You can save the output of a form letter, mailing labels, or envelopes as a file, rather than printing it directly. Saving as a file is useful for several reasons. For example, you may want to view the file to make sure it is correct before printing a large number of form letters or mailing labels, or you may want to edit the file (change the typeface, the type size, indentation, and so on).

To save as a file rather the printing directly, select the Mail Merge Wizard at the point where '''File > Print''' would normally be selected.

Thus, after selecting '''New Document''', instead of selecting '''File > Print''', do this:

# Select '''Tools > Mail Merge Wizard'''.
# In Step 1 of the wizard (Figure 23), select '''Use the current document'''.
# Then select step 8 ('''Save, print, or send'''). In step 8, you can save the original sample letter, save the merged document, or print the letters right away. In the example below, '''Save merged document''' and '''Save as single document''' are selected. You can also save as individual documents, which means that there will be a separate document for each record. In most instances, saving as a single document is more desirable.

<center>[[Image:|thumb|<center>''Figure 37: Step 8: Save, print or send''</center>]]</center>

# Click '''Save Documents'''. You will be prompted to give the document a name. You then return to the above dialog, where you can choose another option (for example, save the starting document), or click '''Finish'''.

== Editing a saved file of mailing labels ==
You can edit individual records in the normal fashion, by highlighting and changing the font name, for example. However, you cannot edit globally (changing the font name for all records, for example) by selecting the entire document. 

[[Image:]]To make global changes, you must edit the style:

# Right-click any correctly spelled word in a label record. Select '''Edit Paragraph Style''' from the popu-up menu. (Note: If you click on a misspelled word, a different context menu will appear.)
# Then from the paragraph style dialog, you can make change to the font name, the font size, the indents, etc.


= Removing blank lines in addresses =
A common situation is that some addresses may have no information in some fields. For example, you may have an “address1” field and an “address2” field to deal with multi-line addresses, or a “company name” field that may be blank in some cases. When you print a form letter, address label, or envelope, you will not want a blank line to appear when the field is empty. This section describes how to suppress blank lines. 

<div align="right"><div align="right">'''''Note – Very Important!'''''</div>

<div align="right">''Be sure your field names (or column headings in a spreadsheet) do '''not''' contain spaces or the technique described here does not work. ''</div>

<div align="right">''Normally you would enclose a field name in quotation marks if the name contains a space. However, a quoted string is not acceptable in the Condition box for a hidden section (see Figure 40 and Figure 42) and an un-quoted string stops on the first space in the field name, effectively making the condition always True and causing the section to be hidden even if the field has data in it..''</div></div>

== Removing blank lines in addresses on form letters ==
# Figure 38<nowiki> shows a typical address block with field highlighting on. The field <ad2> is the second address line, which may be blank for some addresses, so you want to have that whole line hidden if the field is blank.</nowiki>

<center>[[Image:|thumb|<center>''Figure 38: Typical address block''</center>]]</center>

# <nowiki>Select the <ad2> field, and then select </nowiki>'''Insert > Section''' from the menu bar. In the Insert Section dialog (Figure 40), select the '''Hide''' checkbox. In the '''With Condition''' box, type the field name (<tt>ad2</tt> in this case) and <tt>EQ ""</tt> (which means “equals a blank record”). Click '''Insert'''. 

Back in the document, if you have section markers showing, you will see something similar to Figure 39.

<center>[[Image:|thumb|<center>''Figure 39: Section containing second address line''</center>]]</center>

<nowiki>Now, when you do a mail merge using this document, the line inside the section (including its paragraph marker) will be hidden if the field <ad2> is blank.</nowiki>

[[Image:|thumb|''Figure 40: Setting a condition for a hidden section'']]

== Removing blank lines in labels ==
The process for removing blank lines in labels is a bit different.

# When setting up your labels (as described in “[[#Printing mailing labels|Printing mailing labels]]” starting on page [[#Printing mailing labels|8]]), select the '''Synchonise contents''' checkbox on the Options tab of the Labels dialog (Figure 13). Continue as described in that section.
# When you click '''New Document''', a page of labels is displayed, showing the field names. If you do not already have paragraph markers showing, display them now. (Click the '''Nonprinting Characters''' icon, which looks like a backwards P.) Notice there is only one paragraph mark in each label, at the end of the last line (Figure 41).

<center>[[Image:|thumb|<center>''Figure 41: Labels showing only one paragraph mark each''</center>]]</center>

# To make this technique work, you need to have a paragraph mark at the end of each line. To do this, go to the first label (upper left corner), place the cursor at the end of the first line, press ''Enter'', and then press ''Delete''. This inserts a paragraph mark at the end of the first line. Repeat for each of the other lines except the last. Do this only in the first label.
# Click the '''Synchronize Labels''' button in the upper left. Now all the labels have paragraph marks at the end of each line.
# <nowiki>In the first label on the page, select the field you wish to hide if it is blank. In our example, that is <ad2>. Click </nowiki>'''Insert > Section '''on the menu bar. In the Insert Section dialog (see Figure 42), select the '''Hide''' checkbox. In the '''With Condition''' box, type the field name (<tt>ad2</tt> in this case) and <tt>EQ ""</tt>. Click '''Insert'''. <br/> <nowiki>The <ad2> line in the first label may disappear. Do not be concerned if this happens.</nowiki>

[[Image:|thumb|''Figure 42: Setting the condition for a hidden section'']]

# Click '''Synchronize Labels'''. Now all the labels look the same.
# Select '''Tools > Mail Merge Wizard'''. In Step 1 of the wizard (Figure 23), select '''Use the current document'''. Then select step 8 ('''Save, print, or send'''). A labels document is created, and the last page of the Mail Merge Wizard remains open (Figure 43).

<center>[[Image:|thumb|<center>''Figure 43: Saving the document you just created''</center>]]</center>

# Select '''Save starting document''' and click the '''Save starting document''' button. This saves all your work setting up the labels. 
# The dialog remains open. Select '''Save merged document''' and '''Save as single document, '''or select '''Print merged document'''. All the pages of labels are printed or saved.

<center>[[Image:|thumb|<center>''Figure 44: Saving or printing the merged labels''</center>]]</center>

== Removing blank lines from envelope addresses ==
After you set up the envelope (see [[#Printing envelopes|Printing envelopes]]), use the technique described in steps 1 through 5 in [[#Removing blank lines in addresses|Removing blank lines in addresses]] to remove the blank lines. Then continue with printing the envelopes as described in [[#Merging and printing the envelopes|Merging and printing the envelopes]].


{{CCBY}}
[[Category: Documentation]]