need to print labels from a spreadsheet, like in the old days. Can't find where this is done. is it possible?
Mac OS X (10.5.8)
This is ridiculous! I'm following these instructions to the letter, and it won't let me customize the number of fields. If I don't have the exact fields on my spreadsheet that the envelope template requires, I can't move on. Printing mailing labels shouldn't be this difficult. Argh!
BE,
What Avery label sheet number are you using?
Jerry
I haven't picked one yet. The last time I did this I was using either Appleworks (or Clarisworks) and more recently, Office Mac. In each, they listed various Avery labels, you picked one for your format, then bought the appropriate label for printing.
I'm wanting a set up where I tell it to use first name, last name, address, city, state, zip and it automatically prints a label for each entry I have. It's over 900 entries, so I don't want to enter them manually into one of those Pages templates.
Thanks
BE,
OK. If you get around to selecting a label type, I'd be willing to take a crack at some options for you. Numbers has no built-in capability such as you described.
Jerry
I've remembered what I used to do. It was in Apple's word processing app. There was a Merge Documents option. When you selected this, you could choose a spread sheet to merge with. You would enter fields that you wanted the word processing to pull from ie: first name, last name, address, etc. then merge them and each label would be a different name and address. But I don't see that possibility in Pages either. I'll look at the office supply store and get a pack of labels and get back to you, unless you have any insight on Pages and it's capability.
Thanks
You can merge from address book OR Numbers to a Pages document. Review the Pages Users Guide:
http://support.apple.com/manuals/#productivitysoftware
Chapter 11 Page 246
Another poster here in the last few days fired up an old Mac running Word rather than figure out what to do with Pages. I take that as a challenge. I think I could come up with a template is less time that it took him to set up the old system, whatever that was.
🙂
Jerry
The basic procedure is:
1) Open Pages
2) Open an Envelope template from the Word Processing group
3) select the menu item "Edit > Mail Merge" to start the merge process
4) select whether to take merge data from a Numbers document or the address book
5) map how the fields in a contact map to the fields on the envelope by exposing the merge fields
6) merge to a new document for your review before printing
That's what I was looking for Wayne, "mail merge"! I read the manual page you posted earlier and I'm going to make my own label template and do the mail merge process to print. Thanks!
Yeah, I thought of that too, but as awesome as Pages and Numbers I knew there still had to be a way to do it. Thanks guys!
Ember,
If you find that you would like to print to more than one label at a time, post back here and we can give you additional instructions.
Jerry
Jerry,
I'm making a table right now and plan on sizing it up to match a sheet of labels with 30 per page, but any input on this would be great. Thanks.
Uh, yeah, I tried my table and it input the same address for each label.
So, problem solved?
Jerry
When I do it the way explained, I get one "evnelope" per person. Is there a way to get them to print on peel and stick address labels? Like the 3 across, 10 down sheets of address labels.
Thanks in advance
Brian
can i print mailing labels from numbers spreadsheet
