Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
I too have struggled with this for far too long. I have MS Works on my PC which is dead simple for making labels. I am an editor and I have 500 or so labels to print every two months. Now that I have a Mac (had it two yrs) I am still making labels on the PC because I cant figure out how to do it on my Mac.

There is some kind of problem between MS Works and Mac Mail. I also have Avery Design Pro and that doesnt let me do it either, unless I want to type out all 500 names and addresses, and I sure dont want to do that!

I have had help from many PC and Mac people and we have not yet found any way to take my MS Works file and turn it into something that will print labels on a Mac. I keep an old PC around just for the ability to make labels. Some day that computer is gonna die and I am gonna be out of luck unless Mac gets it together to find a simple way to print labels. That's my only complaint about Apple computers. If anyone has any ideas I'd love to hear them.
Thanks :(

I too have struggled with works files on the mac. Here's what I usually do:

1) Open up the file in MS works

2) Select Save As from the File Menu, and set the file type to doc

3) Move the .doc file to the Mac

4) Open the .doc with Pages (or Word, etc)

That being said, you may want to find a way to import these names / addresses into a numbers document, or into the address book, and then use mail merge to create labels.

I have a windows only app that generates an Excel document of names / addresses. I convert that to Numbers, and then use it for mail merge.
 
printing labels with on a mac

You can use your Address Book on the mac to print your labels. Open Address Book and Import your list (excel file, etc...) then in the Address Book application select print - waalaa - you will see the print labels option - adjust any other settings like paper type (avery,etc...). Hope that helped;)
 
Labels on mac

Has anyone tried Label Maker Professional for Mac ? I only know about it trhough Google, and I just downloaded a trial version. Try it out and see if suits your purposes.

http://www.macshareware.com/review/label_maker_professional_for_mac

I also have another question. I have an old AppleWorks database with all my addresses on it. Is there any way to export it into Address Book or any database program?
 
Printing address labels

I am running 10.4.11 If I try to import an excel or numbers file the only choices address book gives me are vcards ldif or text file and none of those work.m similarly I cannot import .xls files or numbers files into pages.

Whats' up
 
Has anyone tried Label Maker Professional for Mac ?
If I were you I would try Labels & Addresses, which is about the same price as this, but is more intuitive and has more pleasant look imho.

I also have another question. I have an old AppleWorks database with all my addresses on it. Is there any way to export it into Address Book or any database program?
Can you export AppleWorks database into Excel (CSV) format? You will then should be able to import your database to Address Book. I hope this will work.
 
I need to print sheets of address labels using iWorks Numbers as my data source
I don't want to put all these address into the address book.
I can set up a sheet of labels with the merge fields repeated on each label - no problem.
However, merging this gets me 14 identical labels for the first record on the first page, 14 for the second record on the second page etc.
How can I get 14 labels from 14 different records on one sheet? It's dead easy in MSWord - I can't believe that Apple haven't included this so I guess I'm missing something somewhere - any suggestions?
Thanks
Alan

This exactly sums up my problem, anyone have an answer for this problem?
 
labels on mac

go to "onlinelabels.com" and click the "software & templates" button at the top. then go to "maesrto label designer".

I think it's pathetic that a company like apple doesn't have a simple label merge/maker in their word processing software.

or even a save button. i really like their software, but it is missing some pretty basic stuff.
 
go to "onlinelabels.com" and click the "software & templates" button at the top. then go to "maesrto label designer".

I think it's pathetic that a company like apple doesn't have a simple label merge/maker in their word processing software.

or even a save button. i really like their software, but it is missing some pretty basic stuff.

Boy, you've got THAT right. I just looked at this feature in Pages this morning and was sorely disappointed! Printing from the Address Book is fine for my business or personal contacts, but if I'm doing a mail merge at work, chances are I don't want to add those names to my address book.
 
Thanks and another tip

Thanks for the tips. I just used AddressBook to easily make very nice mailing labels, specifying my Avery form in the AddressBook layout dialog of the Print dialog.

Some might find putting all addresses into AddressBook a pain, but if you get Bento, you can easily cut and past from any spreadsheet-oriented data source. A Bento address database uses the exact same data as AddressBook, and you can go back and forth. I import and export using Bento, and view and use in AddressBook. Using Bento I firehose all my old and new contacts lists into AddressBook, and create custom list printouts.

Then put those addresses to which you mail into a Group in AddressBook (called a Collection in Bento) for easily monthly mailings. Doing this is like selection songs and putting them into a playlist in iTunes. Command-Select and drag and drop into your pre-created Group. That way you can have as many addresses as you want in the main database, and just deal with your selected ones in Groups. That way you are not bothered if there are corporate names in your database.

When you are ready to print mailing labels, select the Group, <Command>P, ensure the Avery number is still the one you want, load label stock and hit Print.

For other labels I use the Avery .doc templates in Pages.

If you are still not convinced that that you should keep every and all addresses you ever run across in AddressBook, try creating a letter using a letter template in Pages. You grab a card from Address Book and drop it on the letter. All the right places now have the data from that card. Sick. Now I wonder why I kept firing up Word just to print an envelope all those years.
 
Hi, I'm new here, and new to Macs, so maybe this has been answered before somewhere but this thread doesn't seem to come to any definite answer to my problem.
I need to print sheets of address labels using iWorks Numbers as my data source - I don't want to put all these address into the address book. I can set up a sheet of labels with the merge fields repeated on each label - no problem. However, merging this gets me 14 identical labels for the first record on the first page, 14 for the second record on the second page etc. How can I get 14 labels from 14 different records on one sheet? It's dead easy in MSWord - I can't believe that Apple haven't included this so I guess I'm missing something somewhere - any suggestions?
Thanks
Alan

Set up a new user and just import your data into that new user's address book. Maybe not a perfect solution, but it will do what you want it to do.
 
Hello: Did you receive an answer to this? I, too, want to print Labels, Name Badges, etc, via a mail merge, in iWork Pages. I understand how to accomplish the mail merge in pages, but I cannot find a template, etc to use for the labels or name badges. I have been using my iMac since March and really find it to be a huge improvement over a PC, but I am still struggling with certain aspects of formatting, etc. Thank you.


Printing name badges via mail merge is not possible in Pages '09 currently. You can't use Address Book, either, because there is no way to omit address information when printing labels in Address Book. However, here's a workaround that I came up with. It's not the best, and kinda sucks that there has to be a workaround in the first place, but this produces a suitable result, even if the process is a little bit of a stretch. I used this to print name badges. It might take more fidgeting to get labels to come out right, but once you get it set right, you can save it as a template under the File menu in Pages.

The short answer is to use a custom paper size in Pages so that each label comes up as ONE page, instead of giving you a standard size page with several labels with the same name on it. You dig? So you'll make a small paper size (the size of your name badge or label) and then print several of those pages on one sheet of paper by using some print settings. If you think you can figure it out from that short explanation, go get 'em tiger!! If you're still wondering "wha???" then here's a step-by-step below.

1) open Pages. Set your document paper size to whatever size you want your labels or name badges to be. [you may need to manually measure the label paper.] You can set the paper size under the File menu-->Page Setup.

I did it in page layout mode and set my page size to w=3.5 h=2 with 0 margin around the entire thing.

2) set up your label or name badge with the appropriate or desired merge fields. You can do this by using the Insert menu. Add your desired formatting like font style and graphic decorations.

I just used a single text box and inserted the First and Last name merge fields. Then I centered them vertically and horizontally so the name sat squarely in the middle of the layout.

3) Select the cards you want to merge in your Address Book and drag them to the merge fields in your document. Merge to new document. You can send to printer, but we're going to change a few print settings either way.

4) If you haven't already, go to File-->Print and the print dialog comes up. [make sure you are looking at the expanded print view. if you are wondering what this is, here it is: the first thing you'll read at the TOP of the print dialog box is "Printer:", then a drop-down menu to the right of that, and then a little blue box with a black triangle in it to the right of that. click on the triangle. if the print dialog gets smaller, click the triangle again]

After the "Copies:" and "Pages:" areas, there is a drop-down menu. Make sure that is set to "Layout." The first thing under that drop-down should be "Pages per Sheet:". You can experiment with this for yourself, but at the paper size I used, I found 9 to be a suitable amount of pages per sheet. [so basically what we're doing here is printing 9 pages at 3.5in x 2in on ONE sheet of paper.] Next you should see "Border." You can turn that on or off to your liking. I used "Double Thin Line."

5) View in Print Preview. That might be under the "PDF" button on the lower left corner of the print dialog box.

6) Once opened in Preview, you can see what it's going to look like when you print it out. This is really helpful, because when I didn't do this and printed straight from Pages, it did not work the way I wanted it to. Go to File-->Print and pull up the expanded print dialog box.

7) You may have to mess with the scale options near the bottom. I changed it to "No automatic page scaling" but I didn't try the other options.

8) Print out your document!

9) [Optional] Go back to Pages and save as a template for later use. You can do this under the File menu. When you save it as a template, don't save the merged document with the several dozen names in it. Save the original document that you started with before merging. It should only be one page (one little page). Once saved as a template, it will show up at the bottom of your Template Browser in Pages.
Now, of course, you would have made any tweaks back in Pages before printing it out and/or saving it. I hope that solves your problem.

I know it's pretty round-about, but isn't that the nature of work-arounds, anyway? :) A better idea, though is hitting up the feedback page. www.apple.com/feedback and telling them what feature you want to see in the next incarnation of iWork. That's what I did!! All the best.
 
Avery Labels

I usually print out my Mailing Labels from Microsoft Excel on my PC but now that I've switched machines I'm trying to do the same thing on my Mac. I still have the same spreadsheet but for the life of me I can't figure out how to print labels.

Any help or an easier way of doing this?

Thanks

Josh

Try DesignPro this should give you access to all the Avery labels
 
printing labels in iwork

I gave up go on AVERY website download label software for mac it is brilliant no problems
hope this is helpful B Parker
 
The problem is iWorks Numbers is not Apple Works

Apple should be lashed with a willow branch for dropping Apple Works which had a fine database program. They only offer iWorks Numbers as a substitute, but if you really want to use the U.S. Postal Service you're out of luck. I can't even import my just completed 325 names and addresses into Office Excell, and I can't find a 30-up per page formatting tool in Numbers.

I really don't think anyone answered the original question. How do you PRINT OUT mailing labels (aka ADDRESS labels) from a Numbers database?

When I upgraded my iMac operating system from Tiger to Leopard my old Apple Works program would not work and was made obsolete. I should have type all these fricking 3125 addresses on my old 1992 Mac PowerPC 7200 and printed them on my still functional 1991 Apple Laserwriter Pro! Neither of which has a USB port.

Thanks for the regressive advancement in technology Apple.
 
Apple should be lashed with a willow branch for dropping Apple Works which had a fine database program. They only offer iWorks Numbers as a substitute, but if you really want to use the U.S. Postal Service you're out of luck. ....
OK. Numbers is a spreadsheet, not a DBMS. If you want a small DBMS with Apple's fingerprints on it, then Bento from Apple subsidiary FileMaker is what you want.
 
So why didn't Apple include Bento in iWorks?

I bought my first Mac in the late 1980s for $2700, but at least it included a fricking database program that worked!

Isn't that an important enough reason to by a computer? Killing off Apple Works only makes sense if they want you people to buy Filemaker Pro...and the last I heard Apple owns it or a piece of it.

This is a terrible way to treat long time customers.

So can Bento open my Numbers file of addresses?
 
"next record"

So basically what I'm understanding here is that there is no way to print customized labels in Pages?

Printing standard labels seems to be fairly easy, but I work with large databases (like several others here, none of which I want imported into my personal address book) and often need to print a custom code on the label - or add a logo to it.

Similar to the post above regarding name badges. I can get Pages to create a whole page of one label, and then it automatically creates the next page with the next record, but can't for the life of me figure out how to get a full page with each a different record.

Complicated workarounds aren't really an option - MS Word does this very well and quite easily, but I - like many - am trying to leave MS in the past and make a full conversion to mac...
 
So basically what I'm understanding here is that there is no way to print customized labels in Pages?

....
Since before The Flood, it has been called mail merge. Rather than ranting and raving and foaming at the mouth, you would do well to read the Pages Help menu. When and if you do, you will learn that Pages mail merge is integrated with the Address Book rather than using text files.

It is helpful to understand that Pages was not designed nor was it intended to replace Word. Pages is a small word processor/layout editor that satisfies most users most of the time. Word includes everything except the kitchen sink. Back in the day, it was known as a full-featured word processor. However, Word is not the only full-featured word processor application available on the Mac; it is only the most famous--and least reliable.

If you want to leave Microsoft behind, then you should be willing to support developers other than Microsoft. Fortunately for cheapskates, that is not required. There are free full-featured word processors available for the Mac. They even read and write Microsoft formats. Get off your duff and do some research. A browse of a listing of available Mac software will teach you a lot.

It is better to light a candle than to curse the darkness.
 
Printing Labels on the Mac
Download and open DesignPro.App from Avery Website.
Find label number, Perhaps there will be two choices for the label, 'Fill Across' or 'Fill Down'
Then 'Choose Design' or Use Blank - bottom right corner.
To the right will appear a label unit.
The first label highlighted will be the top left if labels have multiple columns and rows, if you wish to change, then click the required label on the page facsimile on the left that you wish filled in. E.g. using only part of sheet so might wish to use bottom row only.
Select All Same: 'Off' or 'On'.
Click on Text icon - a label will be highlighted with a note to 'Place your text here', double click on it and enter your text. No need to highlight again, so choose Font, B, I or U and font size. Also Position, Left, Centre, Right or Justified.
Unless you have selected All Same: 'On'; Continue with succeeding labels by clicking on 'Panel View: Next. Should the Next not result in the label that you want, you can override by physically clicking on the preview of the label you wish to be next. Click on the Text icon again and continue to the end of the labels you wish printed. Then Control P to print
 
I posted this question as a new thread and didn't get any replies. I'm hoping by attaching it to this thread I might get an answer from someone already using iwork.

iwork questions:

I want to print a full page of labels with graphics/photos. Specifically, a full page of identical labels with 3-4 pictures and several text boxes. (I use the labels on wine and beer bottles). Will iwork 09 - specifically Pages - do the job for me? I'm not talking about importing address files.

Additionally with iwork, can I make a single page document and import 15-20 pictures from iphoto and still add text - kind of like a collage?

I used to be able to do this with the old version of Word. The new 2008 Office Mac2008 student/home version does not work (been there done that with the Microsoft support staff).

How didi you make your labels with old Word version please and what version? Thanks. Marylise
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.