how to print address labels from excel speadsheet

The Avery app allows you also to merge directly from Address Book or Mail and you can upload artwork or photos. Click on the 'Mailings' tab and select 'Start mail merge.' Select 'Labels. you choose a label type… an avery number… a design type… you mail merge your CSV file… and you’re away. If you’re looking for standard, white, peel & stick Address Labels (which look great on Postcards & Envelopes), we recommend using Avery 5160 Mailing Address Labels. Download the design pro app from Avery ( )ģ. Use the function Link data sources by clicking on the icon in the left toolbar and follow the instructions. Step 1 : Choose Your Address Labels There are lots of different types of Address Labels to choose from. Export your numbers file as a CSV file (make sure that you’ve made the first line in each column a heading)Ģ. For example, the columns might be name, street address and city-state-zip. Thanks to Paul Sheely for this pointer on how to export from an apple numbers file into the avery application:ġ. The Excel spreadsheet should have columns for the fields to be printed on the labels. I just downloaded it (262 MB!) and it looks pretty good. Avery has just released a free program designed to be able to print on any of their labels, of course you can use them to print on anything, but they work well with the Avery stuff because you can just type in the number from the packet and it has all the sizes already.

How to print address labels from excel speadsheet