![Template for avery 5931 cd labels Template for avery 5931 cd labels](http://www.sticker-world.co.uk/289-large/a4-label-sheets-2-per-sheet-avery-compatible-l7168.jpg)
Mac Label Make with most of the Avery labels and cards formats support and powerful mail merge feature. The product supported Post Net barcode and can be used for barcode generating. Additional Word 2011 create avery labels selection. Acoustica CD/DVD Label Maker is a graphics editing tool to create disc labels. It is a very. If you use Microsoft Office 2011 with a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts and place them onto Avery labels, name.
Are you trying to print a set of labels from an address list stored in, FileMaker, or your Apple Contact list? If so you are going to love this guide.
In the steps below I will show you how to print labels from a list using Word 2011. For those of your coming from Office for Windows you will notice that there a lot of differences between Mail Merge in Windows and Mac, but I’ve detailed each of the steps below to guide through the entire process. If you have any comments or questions please use the comments form at the end of the guide. Software/Hardware used: Excel 2011 and Word 2011 running on Mac OS X.
Before proceeding the first thing you need to do is ensure that you have a properly formatted Excel spreadsheet to use as the data source for your labels. Try to keep data fields like Address, City, State, and Zip Code in separate columns (see example below). How to Print Labels in Word 2011 with Mail Merge Manager Open Mail Merge Manager in Word 2011 1. Create a blank document in Word 2011 and click. Click Mail Merge Manager from the list.
Prepare Mail Merge for Label Printing First thing we need to do is select the document type that you will be printing. In this case we will be printing labels, but you can also print form letters, envelopes, and catalog.
In the Mail Merge Manager window click on Select Document Type to expand the selection. Click the Create New button to select Labels from the list.
Select the Label product company from the list, in this example I used Avery label number 5161. Make sure to select the company and label number. Verify that the label dimensions are correct and click OK. Now that we have the correct label selected we will need to select the data source for the names and addresses that will be printed on the labels, expand the Select Recipients List section in the Mail Merge Manager to continue. Click Get List and select Open Data Source from the list. Note: This is where you can choose a FileMaker database, Apple Address book, or Office Address book as a data source. When the dialog box opens select the pre-formatted Excel spreadsheet containing the address list and click Open.
You will see the following prompt, click OK to continue. Select the sheet that contains the address list data from the Excel workbook. If you have a specific range you wish to select enter it in the Cell Range text box, click OK to proceed. So we’ve got the label type selected and we have the data, let’s tell Mail Merge what data fields from the list to use for the label. Use the Insert Merge Field drop-down to select the fields you wish to include in the label. In my case the spreadsheet had columns (fields) for Name, Address, City, State, and Zip Code. Choose each of the fields to add them in the order you wish to appear.
You should also take this opportunity to place spaces and commas to divide the information. Example: Notice that I placed the Name, Address, and City/State/Zip fields in separate lines and that I added a space and comma between City and State.
Formatting is up to you, but this will ensure that when the data is pulled it isn’t bunched up together. When you are ready to proceed click OK. If you click OK and wish to edit the data fields use the placeholders in the Insert Placeholder section to drag fields to the label sheet. We’re almost ready to print, but before we do that let’s see what the labels will look like. Click on the View Merged Data button in the Preview Results section to see what your labels will look like. Take this opportunity to format the labels with the standard formatting tools.
You can change font size, color, alignment, and more. You can navigate through all of your labels by using the Next Record and Previous Record buttons. Note: You may want to preview all of your records to ensure that a name doesn’t stick out or overflow in one of your labels. When you are ready to print, click on the Merge to Printer button.
![Word For Mac 2011 Avery 5931cd Labels Word For Mac 2011 Avery 5931cd Labels](http://apocconvergence.info/wp-content/uploads/2018/04/dvd-labels-word-template-cover-size-label.jpg)
When the Print window appears, select the appropriate settings for the print quality and paper size. Click Print to print the labels. You are set, your labels should print shortly. You can save the document should you wish to print the same labels in the future. If you have any comments or questions please use the comments form below.
Gilbert is a Microsoft MVP, a full-time blogger, and technology aficionado. When Gilbert is away from his bike and his iPad, he's busy writing technology how-to's from his home-office in Miami, Florida on the latest programs and gadgets he can get his hands on. He's locally known as 'the computer guy' and has spent the last 12 years helping family, friends, and GilsMethod.com visitors with their computer questions and problems. He was awarded the 2009 MVP award from Microsoft for his contributions in forums and blogs and is enjoying the new addition to his family.
This is an Avery Shipping Labels Template for your Mac using Apple Pages, with each label being 1″ x 4″ and 20 labels per sheet. Fits various Avery sizes. You can use the following Avery Print Paper Templates with this:. Avery Shipping Label 5161. Avery Shipping Label 5261. Avery Shipping Label 5661. Avery Shipping Label 5961.
Avery Shipping Label 8161. Avery Shipping Label 8461 What you get with the Avery Shipping Labels Template – 20 Up for Apple Pages: This template includes the following:.template – The true template file extension for a pages template. You can use this again and again and this template will remain intact and untouched.pages – The modern file type for Apple Pages If you don’t have Pages you can download it by going to.