Skip navigation
This discussion is archived

Numbers-- need to make address labels

8168 Views 11 Replies Latest reply: May 18, 2008 5:50 PM by bird2008 RSS
MarianneBD Calculating status...
Currently Being Moderated
Feb 14, 2008 7:55 AM
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,085 points)
    Currently Being Moderated
    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.

    24" 2.4 Core 2 Duo iMac; G5 2.3GHz; 15" MacBook Pro 2.0; 30GB 5G iPod, Mac OS X (10.5.2), TV, iPhone, 2GB iPod nano, G3/600 iBook, G4/700 iMac, PB 1400, Apple IIgs
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    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)

    :ForNumbers:pourétiquettes.numbers.zip

    Yvan KOENIG (from FRANCE jeudi 14 février 2008 18:26:20)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
  • briegull Calculating status...
    Currently Being Moderated
    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
    macbook pro, Mac OS X (10.5.1), vmfusion, iWorks, Firefox
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    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)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
  • briegull Level 1 Level 1 (0 points)
    Currently Being Moderated
    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!
    macbook pro, Mac OS X (10.5.1), vmfusion, iWorks, Firefox
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    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)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
  • briegull Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 15, 2008 4:50 AM (in response to KOENIG Yvan)
    Not in the least!!
    macbook pro, Mac OS X (10.5.1), vmfusion, iWorks, Firefox
  • estibot Level 1 Level 1 (0 points)
    Currently Being Moderated
    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
  • Peggy Level 8 Level 8 (38,085 points)
    Currently Being Moderated
    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.



    24" 2.4 Core 2 Duo iMac; G5 2.3GHz; 15" MacBook Pro 2.0; 30GB 5G iPod, Mac OS X (10.5.2), TV, iPhone, 2GB iPod nano, G3/600 iBook, G4/700 iMac, PB 1400, Apple IIgs
  • bird2008 Calculating status...
    Currently Being Moderated
    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.
    Mac OS X (10.5.2)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.