can i print mailing labels from numbers spreadsheet
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)
Apple Event: May 7th at 7 am PT
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)
burningember wrote:
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.
As I noted above, I can't help you without knowing the Avery label style number, since I presume you would want the 30 sets of fields to actually print on the labels, not just anywhere on the sheet of labels.
Jerry
It would be Avery 5160's
Thanks.
Brian
Just jumping in here (looking for info to set up a customer database). As for the "envelope" issue - I used to use to send out newsletters to our bulk mailing list, and we switched to peel & stick address labels. In Microsoft Word, the mail merge option would let you use a sheet of labels instead of printing out individual envelopes. It might just be a case of choosing the Avery 5160 (in your later post) as the envelope under the formatting options. So, basically, in this case I think of "envelope" as a place-holder name, rather than being a mandatory item.
Kate and Jerry,
So I've got an employee and a friend trying to figure this out on a PC and I on a Mac and we're getting no where! What I'm doing right now is printing straight onto the post cards as single envelopes, which is working for now, but is kinda a pain since there are nearly 800.
So, Kate can you elaborate?
Jerry, if we did use the Avery 5160, can you figure out how to get a separate address on each label?
Kate and Jerry,
So I've got an employee and a friend trying to figure this out on a PC and I on a Mac and we're getting no where! What I'm doing right now is printing straight onto the post cards as single envelopes, which is working for now, but is kinda a pain since there are nearly 800.
So, Kate can you elaborate?
Jerry, if we did use the Avery 5160, can you figure out how to get a separate address on each label?
I was struggling with this too, but then used the Avery.com online tool. I had to export my Numbers file as CSV, but then it was super-easy to pick the Avery form number and format the data how I wanted, then export as PDF from there and print on labels.
Thanks Ted. I just discovered this and did it last week. Saved the day. It's how I'll do it from now on until an easier solution is developed by Apple.
The mail merge disapeared from the latest update!! Just when i set everything up and needed to print a lot of envelopes. Anyone got a different solution?
Go back to Ver 2 for this particular work. That's my suggestion. Maybe this will blow over. Or, maybe a third party solution will appear.
Jerry
I took someone's advice when I asked the same question and used the Avery.com tool and that's solved my problem.
That sounds like a great third party solution for labels. If the question involves printing directly on envelopes, it may not be so great. Have you checked this out?
Jerry
I did and it looks fine for labels, but nothing for printing on envelopes. I tried to trick their tool and use a custom size, nothing fits.
I can't believe I am going to print on labels I will then put on my envelopes :D.
Try saving address as .csv, import as a new group in contact, then print the group directly into whatever label or envelope or card you want.
I have tried and failed to follow the instructions above, but have found a way to do it. Go to Avery.com or Avery.co.uk and select Templates and Software. Do not download any software, but select Avery Design and Print Online. This will allow you to specify what Avery label you are using and design the label. When you get the part where you want to merge your data, do not use the Numbers File, but instead open it and under FILE, EXPORT select CSV and save it. Use the CSV file to merge. Don't put your address text box too near the top or bottom of the label or you may find a small bit gets trimmed off. If your Avery label reference is not found then try .com or .co.uk (there may be other national wen sites not known to me).
can i print mailing labels from numbers spreadsheet