

Imp! If you need to make changes to your labels, always change the one in the top left corner only and then select Update Labels to copy the changes to all the other labels. When the top left label looks perfect, click update labels to copy those fields to all other labels. Click the Mailings tab in the Ribbon and then click Start Mail Merge in the Start Mail. The first step is to start the merge using Start Mail Merge on the Mailings tab in the Ribbon: To start the merge and specify the main document for labels: Create a new blank Word document.

In the following examples I have toggled-on the formatting information ( CTRL+SHIFT+8 - or click the ¶ button on the Home tab of the Word ribbon) to demonstrate more clearly what is happening. Step 1: Start the merge and specify the main document as labels. Select individual fields or the Address Block for the top left label (see Merging letters to insert Fields or Address Block).ġ1. The labels should be converted to a mail merge data source which can be merged to create a new label document. To prevent this: Select the first column and drag the left indent for the first column only, slightly to the rightġ0. Tip! The first column always prints too far to the left. Delete the paragraph symbol if you want your label to have more room for text. Tip! Also notice the paragraph symbol in the upper left corner of the first label. Tip! If you cannot see the layout of your table (because table gridlines are not shown) select View Gridlines on the Table Tools Layout tab.
#Mail merge address labels manual
Choose the Label vendor, Product Number and whether you want manual or Automatically Select printing or a specific print tray. After you click OK, select Setup on the Mail Merge Helper Dialog box.Ĩ. All contact fields (this doesn’t mean you need to use all contact fields, it just means all of them will be available IF you want to use them).Ħ. Only selected contacts (unless you want all the visible contacts merged)ī. Select the following options on the Mail Merge Contacts dialog box:Ī. Select Home, Mail Merge on the menu bar.ģ. If the names are not next to one another on the list:Ĭlick on the first name and Ctrl + click each subsequent name.Ģ. If the names are next to one another on the list:Ĭlick on the first name and Shift + click the last. Tip! To select many contacts at the same time: I can single out the ones who didn’t get mailed, pull them into a new list, and go again.1. What I’m saying is, I don’t think I did anything odd which might have caused such a problem.Īs it stands, I failed to mail out a fifth of my list. The process doesn’t appear to be any different. I used to do a lot of mail-merge with OpenOffice several years ago, but this is the first time I can remember using LibreOffice. All four field-slots on the page are identical. I followed the recommendation of examining the template to see if there was an extra “next record” field, but there is not. Instead, the program is duplicating names and I end up with 83 pages of labels. There are 83 names on the list and I should end up with 3-4 pages of labels. Since I have only four records per page, it appears this is exactly the same problem described by the OP. I am importing an excel file to create mailing labels. It was only later I realized the file created by the mail-merge had skipped every fifth record. Actually I saved the mail-merge output to a file, and then printed from the file. I recently did a mailing in which I printed four records per letter-size page, and cut the page into quarters for post cards. I have a large spreadsheet of names and addresses a mailing list.
