Numbers-- need to make address labels

Question

Level 1

0 points

Numbers-- need to make address labels

I have Numbers on the new computer(MacBook) and Excel on the old one (PowerBook--the Wall Street version).

2 questions:

How do I make address labels from Numbers? I opened Pages, but couldn't get the equivalent of Tools in Excel--or anything else that worked.

I copied the Numbers file from the MacBook to the PowerBook. I could not open the Numbers file in Excel. When I go from the Excel to Numbers, info transfers ok.

I will soon be putting Excel on the new MacBook, but I need the labels today!

Thanks for your help.

MacBook & Powerbook, Mac OS X (10.5.2)

Posted on Feb 14, 2008 7:55 AM

Reply

Answer 1

Peggy

Level 8

41,601 points

Feb 14, 2008 8:53 AM in response to MarianneBD

Welcome to Apple Discussions

Neither Pages or Numbers is designed for doing labels. My guess (& it's only a guess), is that, since labels can be printed directly from Address Book, doing labels in Pages wasn't considered a priority. You could make your own, but there isn't a template. Using a table set up to fit the labels would probably be best, but you'll have to "fiddle" with the sizes & enter all data manually. If you're planning to merge from Address Book, remember that Pages will only merge one name per page.

Reply

Answer 2

KOENIG Yvan

Level 8

41,807 points

Feb 14, 2008 9:26 AM in response to MarianneBD

Hello

You may enter my iDisk :

<http://idisk.mac.com/koenigyvan-Public?view=web>

and download (it's free)

:For Numbers:pourétiquettes.numbers.zip

Yvan KOENIG (from FRANCE jeudi 14 février 2008 18:26:20)

Reply

Answer 3

MarianneBD Author

Level 1

0 points

Feb 14, 2008 9:52 AM in response to Peggy

So there's no such feature on Pages or Numbers like the "Tools>Labels" tab in MSWord? That's a bummer. I have file of over 1000 names and do not want to put them in my address book. Back to the drawing board, I guess.

Thanks for your help.

Reply

Answer 4

briegull

Level 1

4 points

Feb 14, 2008 10:17 AM in response to KOENIG Yvan

Mr. Koenig,

I am trying to retrieve your address labels program on your idisk, and it doesn't seem to download - nor do any of the others there. I am not accustomed to idisk, though I AM accustomed to downloading from the web. Clicking on it says "loading" and then nothing happens. Dragging the file onto my desktop just gets me the .gif, not the .zip. What am I doing wrong?

Thanks - Clare Durst

Reply

Answer 5

KOENIG Yvan

Level 8

41,807 points

Feb 14, 2008 11:37 AM in response to briegull

Hello

When the idisk is reached, you navigate exactly as you do in your HD.

double click on the little arrow pointed on the screenshot and the file will quickly reach your machine (as you may see on the report on the right part of the screenshot.

Are you sure that the file is not already available on your machine?
I don't know which is the default folder used on your machine for downloading.

Yvan KOENIG (from FRANCE jeudi 14 février 2008 20:37:10)

Reply

Answer 6

briegull

Level 1

4 points

Feb 14, 2008 12:20 PM in response to KOENIG Yvan

I apologize. I didn't see the little down arrow!!

Okay. So you merge the fields from the numbers file, fine, and retrieve that into another sheet that is set up in the form of the labels. Now all that is needed is to design that template sheet for Avery 5160s!

p.s. FIGURES that a potter would have a lot of addresses in VALLAURIS! 😉

Reply

Answer 7

KOENIG Yvan

Level 8

41,807 points

Feb 15, 2008 1:36 AM in response to briegull

briegull wrote:
p.s. FIGURES that a potter would have a lot of addresses in VALLAURIS! 😉

Is it surprising when the potter lives in VALLAURIS ?

Yvan KOENIG (from FRANCE vendredi 15 février 2008 10:36:51)

Reply

Answer 8

briegull

Level 1

4 points

Feb 15, 2008 4:50 AM in response to KOENIG Yvan

Not in the least!!

Reply

Answer 9

estibot

Level 1

5 points

Feb 28, 2008 7:49 AM in response to Peggy

erm...Peggy.. how exactly do you print labels from Address Book? I haven't found anywhere that show how to do this.

The address book help says:
Choose File > Print.
Choose Mailing Labels from the Style pop-up menu, and then set other options:

Right, but there's no Style pop-up menu, when I choose File->Print...so much for that.

ANyone have any ideas?
Thanks

Reply

Answer 10

Peggy

Level 8

41,601 points

Feb 28, 2008 8:56 AM in response to estibot

The option is in the print dialog, but you need to expand the window. Like most open & save dialogs, the default is a condensed view. Click the down-facing triangle as in this picture of a save dialog to expand the window.

Reply

Answer 11

bird2008

Level 1

0 points

May 18, 2008 5:50 PM in response to briegull

help! did you create template for avery 5160? how to? i'm having trouble doing so as I'm new to numbers.

Reply