FOR MAC USERS: Can you create address labels with Microsoft Office for Mac?

  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 3:23 AM GMT
    Hey gents,

    I need to send out ~300 thank-you cards pronto. I think printing addresses on address labels would be easier and quicker, but I don't know how to create these labels using Microsoft Word.

    Does anyone know how?

    Please help.

    Thanks.
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 3:28 AM GMT
    Does Microsoft Excel have instructions for it? I'm going to look.
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 3:35 AM GMT
    if you have all the people in your apple address book, you can use address book to print out your labels
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 3:45 AM GMT
    or type them into address book, make a group from all there names, print them out and then, the names are all in your address book for next time.
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 3:50 AM GMT
    indeed, but, here is hoping there will always be more fun gatherings that require thankyou notes sent out!
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 4:08 AM GMT
    lilTanker saidor type them into address book, make a group from all there names, print them out and then, the names are all in your address book for next time.


    Thanks for the tip. I'm doing this for my parents, actually. They want to thank 300+ people. Which means I will have to create a list of addresses, a list I'd rather type than write.

    THANK YOU.

    XOXOXO
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 4:18 AM GMT
    If you're going to be typing each address onto the labels, then try this free download from Avery. Not rated too great, mainly because it's not easy to use, but I manage fine, use it for all kinds of label & card projects.

    http://www.avery.com/avery/en_us/Demos/Software-Demos/Avery-DesignPro-for-Mac.htm?N=0&refchannel=c042fd03ab30a110VgnVCM1000002118140aRCRD
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 4:24 AM GMT
    lilTanker saidor type them into address book, make a group from all there names, print them out and then, the names are all in your address book for next time.


    When I try to print from Address Book, it prints each address on a different page in envelope format.

    How can I make Address Book print as many addresses as possible in label form on each page?
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 4:40 AM GMT
    select the ones you want to print, go to "file - print"

    in the window, select your printer and then left click on the arrow to the right of the select box.

    From there a few rows down, you'll have a selection of "style" and in the selection choose "mailing labels"
  • EricLA

    Posts: 3461

    Jul 21, 2009 4:48 AM GMT
    If you're using Apple's Address Book application, this thread from one of my favorite Mac website, might be helpful:

    http://www.tuaw.com/2007/12/07/manage-your-holiday-mailing-list-with-address-book/

    If you have the addresses is Excel, email me and I can help. I merge documents all the time.
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 5:37 AM GMT
    It's all easy to do with Excel, which you have, and Word.

    In Excel create a top row of headers with Name, Address, City, State, Zip in the top 5 cells (A1, B1...).

    Enter your addresses, or copy/import them (if you know how to do it) from your source material (if it's already been entered on your computer) in each column corresponding with your top row headers.

    Save the Excel file.

    Open Word. Go to menu Tools, and choose Letters and Mailings. Choose the Mail Merge Wizard. Follow the prompts, appearing--I believe--in a pane on the right side of your window.

    Choose Labels. On the bottom of the pane, click Starting Document.
    Change document layout: click Label Options. Select the label size/style parameters from the supplied list. On the bottom click Select Recipients.
    With Use an existing list selected, click Browse.
    Find and choose your saved Excel file as the data source.
    Follow any other instructions/prompts (you should have the idea by now) and do the final mail merge.

    Print the labels on plain white for a registration test (hold label stock and the printed paper up to the light to verify that each label will fit).

    Insert your label stock into your printer (either in the manual tray, as is the default, or set up your print options to pull from Tray 1).

    Incidentally you can also follow this procedure under Tools for printing envelopes. Just choose Envelopes instead of labels.
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 7:48 AM GMT
    BlkMuscleGent said
    When I try to print from Address Book, it prints each address on a different page in envelope format.

    How can I make Address Book print as many addresses as possible in label form on each page?

    Export all the names/addresses from the Apple Address book into a flat file. And then follow mickeytopogigio's instructions for Mail Merge.

    Or read the following tutorials..

    http://support.microsoft.com/kb/294684

    http://office.microsoft.com/en-us/help/HA010349201033.aspx

    http://office.microsoft.com/training/training.aspx?AssetID=RC011205671033
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 8:30 AM GMT
    why on earth would you go to all that trouble when you can do it all from within address book?
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 3:15 PM GMT
    Thanks, y'all.

    I just woke up. I'll try to figure everything out this morning.

    XOXO
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 4:51 PM GMT
    muchmorethanmuscle saidThe only way I know how to do this is with using Windows. I've done this before for a class assignment when I took a class to learn the entire Microsoft Office Suite. .


    It is not a Windows vs Mac OS issue. MS Word is exactly the same in this respect. Under "Tools" there is a "Labels" option. So the short answer to the OP's original query is "yes, there is a built in way to do this in MS Word for Mac."

    Getting the information for the Labels option is a different matter, independent of platform. Either you create the address "data base" in MS Word, or import a list in from Excel (which is what I do each year for my large Halloween party).

    Yes, you can also use Mac Address Book for this.
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 5:13 PM GMT
    BlkMuscleGent said
    lilTanker saidor type them into address book, make a group from all there names, print them out and then, the names are all in your address book for next time.


    Thanks for the tip. I'm doing this for my parents, actually. They want to thank 300+ people. Which means I will have to create a list of addresses, a list I'd rather type than write.

    THANK YOU.

    XOXOXO


    use excel, make a column for names a column for street address, one for city, one for state and one for zip. then just do a mail merge to micrsoft word
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 5:34 PM GMT
    chungo44 said
    BlkMuscleGent said
    lilTanker saidor type them into address book, make a group from all there names, print them out and then, the names are all in your address book for next time.


    Thanks for the tip. I'm doing this for my parents, actually. They want to thank 300+ people. Which means I will have to create a list of addresses, a list I'd rather type than write.

    THANK YOU.

    XOXOXO


    use excel, make a column for names a column for street address, one for city, one for state and one for zip. then just do a mail merge to micrsoft word


    Tabulated data is a turn-on to anyone icon_wink.gif

    You know you're a real nerd though when you enter it into a 3rd normal form MySQL database and export it to Office as CSV LOL!
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 5:57 PM GMT
    yes...you just type in the avery form number for the lablels you are using
  • Posted by a hidden member.
    Log in to view his profile

    Jul 21, 2009 6:01 PM GMT
    Google search!


    How to Make Mailing Labels Using Mac Address Book
    http://www.ehow.com/how_4814271_labels-using-mac-address-book.html

    1.
    Step 1

    Open Address Book on your Mac.
    2.
    Step 2

    Choose the individual addresses or group for which you want to create mailing labels.
    3.
    Step 3

    Go to File>Print. In the "Style" drop-down menu choose "Mailing Labels."
    4.
    Step 4

    Click the "Layout" button (if it is not already selected) and choose the type of label (Avery or Avery compatible number) that matches your blank labels.
    5.
    Step 5

    Make any changes necessary under the "Label" button. This section allows you to change the order in which labels are printed, change the font style and color or to add an image.
    6.
    Step 6

    Insert a blank sheet of labels into your printer and click "Print."



  • EricLA

    Posts: 3461

    Jul 21, 2009 6:11 PM GMT
    One final piece of advice, having merged all sorts of documents, make sure to review every label BEFORE you hit print. If there are any inconsistencies in the way the addresses were entered you'll have labels that don't print out correctly. Once the document is merged, however, you can go in to the document and make custom changes to individual labels. Or, if you run into the same error on a lot of labels, it's best to go back and correct your source document (the Address book entries or the Excel spreadsheet with the addresses) and then merge them again.

    Also, people usually prefer a human touch to thank you notes, which labels usually do not convey. But, you as a compromise, I suggest using clear labels. They're more classy than white labels.