Note: Older versions of Word are slightly different. If you're working in Microsoft Word and your gridlines disappeared, you may need to enable the gridlines in order to see your actual card or label cells. If you use Microsoft Office on a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts and add them to Avery Labels, Name Badges, Name Tags, or other products to edit and print using Microsoft Word for Mac.
These steps will show you how to mail merge onto an Avery template, making it easy to prepare for mailings and meetings. Double-click the Avery Word Template file you downloaded and saved to your copmuter. Once the file is open, type your information into the template. Highlight the text you entered and use the tools in Microsoft Word to format the text.
Select your image in the template and click the Page Layout tab in the Ribbon Toolbar.
How to create a sheet of all the same labels: Blank Templates Insert your information on the 1st label. Highlight all the content in the first label, right-click and select Copy Position the cursor in the next label, right-click and select Paste. Continue with Step 3 until all labels are filled with your information. Pre-Designed Templates: Use the Microsoft Word's Find and Replace formatting tool to replace all the pre-designed template text in each label with your own information.
- ogg vorbis to mp3 mac.
- How to create labels with Pages.
- Popular Topics.
- office 2013 for mac arabic support!
- How to Set Up the Source Document?
- How to Print Labels with Mail Merge in Microsoft Word and Excel!
The fastest way to download an Avery template is to go to avery. Your product or template number can be found on the bottom right of your Avery packaging. You can also search by product category if you don't have your product or template number handy. Once you've located your product, scroll down to the middle of the page to Download Templates. Note: Many Avery products have similar layouts but are different sizes, so make sure you use the correct template for your product.
It's also important to be sure you're using the correct product type for your printer. Inkjet-only products should only be used in inkjet printers, and laser-only products in laser printers. After you select your product, template and a pre-design, the Options for Entering Information screen appears.
Check the box for using an existing data file or creating a new one. Note: If you don't have a spreadsheet with all of your names and addresses, you can start with our pre-formatted files for Microsoft Excel or other database programs. After uploading the data, you can choose which rows of data you want to use by adding the specific fields to your layout.
You can also add punctuation and spaces, and edit your graphics in this phase. Click Next. Your project is now complete. Choose which direction you want to print your labels or cards and Click Finish. Your project is now ready to print. Make sure that you have downloaded and installed Avery Wizard for Microsoft Word.
Start Microsoft Word. If you do not see an Avery tab at the top of the Microsoft Word Ribbon toolbar, click the Office button at the top left and then click the Word Options button.
Print labels for your mailing list
The Word Options screen will appear. Click Go. The Templates and Add-ins dialog box will appear. Click the File menu, select Save As , then type a name for your data. Remember where you saved this file, as you'll need to be able to find it when it comes time to import it into Word. Now that you have an address list in a spreadsheet, you can import it into Microsoft Word to turn it into labels.
Click Blank document.
This creates a new document to work in. Click the Mailings menu. Click Labels.
- Office 2011 for Mac All-in-One For Dummies.
- Starting Your Mail Merge;
- adobe illustrator free download for mac os x 10.5.8?
- classic games formatted for mac list!
- Tips for Avery Templates in Microsoft Word;
Select your label size and click OK. Be sure to select the size that matches the label paper in your printer. Click Select Recipients. A drop-down menu will appear. Click Use an existing list. Select the spreadsheet that contains your addresses and click Open. If more than one sheet is in the workbook, click the sheet with the data in the pop-up box, then click OK. Click Address Block. Select your desired name and address formatting.
Select a format for the person's name in the first large box, then choose a format for addresses that your postal service can use. A preview will appear on the right side of the menu. Click Match fields.
This opens a list of fields that appear in your spreadsheet. Match the fields to the data in the spreadsheet. Each option has its own drop-down menu—click the arrow to view the options, then select the data you want to appear in that part of the address block. Click OK. This returns you to the Mail Merge page. Click Update Labels. The page will refresh to show your address data in the label format. A few menu options will expand.
How to insert graphics into Word label documents
Click Edit Individual Documents…. A smaller dialog box will appear. Select All and click OK. This closes the Mail Merge screen and returns you to the document which now displays your labels. Save your labels.
How to insert graphics into Word label documents - TechRepublic
Now that they are all ready to go, click the File menu, select Save As , then type a name for your labels file. Open the label document in Word. Insert the label paper into your printer.