11 Replies Latest reply: May 18, 2008 5:50 PM by bird2008
MarianneBD Level 1 Level 1 (0 points)
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)
  • Peggy Level 8 Level 8 (38,585 points)
    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.

  • Level 8 Level 8 (41,790 points)
    Hello

    You may enter my iDisk :

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

    and download (it's free)

    :ForNumbers:pourétiquettes.numbers.zip

    Yvan KOENIG (from FRANCE jeudi 14 février 2008 18:26:20)
  • MarianneBD Level 1 Level 1 (0 points)
    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.
  • briegull Level 1 Level 1 (0 points)
    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
  • Level 8 Level 8 (41,790 points)
    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)
  • briegull Level 1 Level 1 (0 points)
    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!
  • Level 8 Level 8 (41,790 points)
    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)
  • briegull Level 1 Level 1 (0 points)
    Not in the least!!
  • estibot Level 1 Level 1 (0 points)
    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
  • Peggy Level 8 Level 8 (38,585 points)
    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.



  • bird2008 Level 1 Level 1 (0 points)
    help! did you create template for avery 5160? how to? i'm having trouble doing so as I'm new to numbers.