![how to use mail merge with avery labels in open office how to use mail merge with avery labels in open office](https://i.pinimg.com/originals/9e/77/27/9e77272bd9f07acf37c4b74b06f1dc3f.jpg)
The design is separated into 30 parts so you can preview how the finished mailing labels will appear as you write.
How to use mail merge with avery labels in open office software#
A template must be used to print on a sheet of Avery 5160 labels using software like Microsoft Word. The Avery 5160 is a self-adhesive mailing label that comes in sheets of 30 labels. Now, on the mail merge menu you can click through the Recipients by clicking the back or forward arrows. If you doing hundreds of labels … I would just spot check them. Steps Create Blank Avery 5160 Labels In Word. Your document screen will look similar to this. This will populate each label with the fields from the fist label. Now over on the Mail Merge menu bar you will want to select the “update all labels” button. For instance on this label I would want the First Name before the Last Name. You can edit them by highlighting the field and moving it to where you want. Now if you look over at your document you will notice these fields are being added to your labels. Just double click on each field you want to include.
![how to use mail merge with avery labels in open office how to use mail merge with avery labels in open office](https://labelsmerge.com/assets/images/guides/gdocs-print-labels/5-create-labels.jpg)
One interesting attribute provided by Word is the Avery Label Templates For Openoffice. With a variety of intriguing features it uses, it fits the needs of everybody who wishes to develop crucial records or basic layouts. Now we can choose the order of the data we want presented on the labels we are creating. Avery Label Templates For Openoffice - Word is the most effective application for producing records. Ok, we’re almost complete, just a couple more steps. Click on Next: Arrange your labels. Since I know the data source is what I want I chose Select All. Here you can change the order of your information, delete certain users, and validate information. You will click on a confirmation screen verifying your data source (I used an Excel spread sheet that I had imported from Access) and get to Mail Merge Recipients window.