Browse to your mailing list file, select it, and press “Open”.

Press “Mailings > Select Recipients > Use an Existing List…”.Select your label options and press “OK”.The mail merge feature will allow you to easily create labels and import data to them from a spreadsheet application. Open the “Mailings” tab of the Word ribbon and select “Start Mail Merge > Labels…”. Once everything has been prepared with the correct column headers, you can save your work and continue to the next step to create labels from Excel. If you’re using your labels for a mailing list, you may want to include heading labels like first name, last name, and title. This will help you to match your fields to the correct columns later on.įor example, in ours we’ll be using the fields property name, operator name, address, city, state, zip code, and country. The important thing to remember is that you must create a column header noting the information that will go in each heading. If you don’t have one, you can create one now. I can single out the ones who didn’t get mailed, pull them into a new list, and go again.Before you can create labels from Excel, you’ll need your existing mailing list in the application.

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. Since I have only four records per page, it appears this is exactly the same problem described by the OP. 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.

Mircosoft office 2016 mail merge lables