can you print Avery mailing labels from numbers

Question

Level 1

8 points

can you print Avery mailing labels from numbers

I have always used an Excel spreadsheet with names and addresses and 'mail merged' into Word to print 250 or so Christmas mailing addresses.

The names and addresses are different than what we have in our Contacts.

I always have used Avery (30 labels per sheet), Number 8160 labels.

Now I'm a proud iMac owner but am having a horrendous time getting the labels printed.

I have all the data moved from Excel to Numbers, but can't get the data into a label template. I looked at the Avery template download but it got terrible reviews from Apple users.

HELP! Please.

Thanks.

iMac, iOS 9

Posted on Dec 20, 2015 2:00 PM

Reply

Answer 1

SGIII

Level 8

37,562 points

Dec 20, 2015 4:02 PM in response to gske

Since you are used to doing this in Excel, have you considered using Office 2016 for the Mac?

SG

Reply

Answer 2

HD

Level 5

4,945 points

Dec 20, 2015 2:33 PM in response to gske

Hi,

Your best bet for printing mailing labels is the Contacts application which is included with every Mac. It has options to print many different Avery labels including 8160.

Have a look at this thread from a year ago (Christmas, coincidentally) which offers a way to extract names and addresses from Numbers and import them into Contacts. But the devil is in the detail - it would need an AppleScript tailored to your Numbers spreadsheet.

Cheers,

H

Reply

Answer 3

FoxFifth

Level 10

475,419 points

Dec 20, 2015 4:03 PM in response to gske

Another option is to use the Avery Design & Print Software for Mac. It is free and works very well. It will import (merge) from an Excel format file and you can use Numbers File menu Export to save your file in Excel format prior to doing the merge. http://www.avery.com/avery/en_us/Templates-%26-Software/Software/Avery-Design--P rint.htm

Reply

Answer 4

SGIII

Level 8

37,562 points

Dec 20, 2015 2:51 PM in response to gske

Just double-checked in Office 2016 for Mac. It's still all there for you.

This is a screenshot from Word.

You can source the data from Excel or Contacts.

SG

Reply

Answer 5

gske Author

Level 1

8 points

Dec 20, 2015 4:06 PM in response to SGIII

Thanks for your help. Since I didn't have Word I was able to find a link at Avery that did end up working. I understand your reply and that was my next move. Have a nice Christmas. G😎

Reply

Answer 6

gske Author

Level 1

8 points

Dec 20, 2015 4:07 PM in response to FoxFifth

Thanks much. This is what I ended up doing and surprisingly it worked great. Thx for the help, have a nice Christmas. G😎

Reply