Ticket Options

Question Profile

Question Details

TICKET ARCHIVE -> Printing postage labels

rosscopeco - Dec 4, 2007 - 2:54 pm

Hi, I have just transferred a large number of names and addresses from MS Excel on my pc to 'numbers' on my mac. In Excel I can normally carry out a mail merge and then print out these names and addresses into Avery labels but I cant figure out how to do this on my mac. Can it be done in 'numbers'? Thanks Ross

Natobasso - Dec 5, 2007 - 12:22 am

[edit: Import a csv file into Address Book, then you can print out the labels right from that app:
http://docs.info.apple.com/article.h...en/ad808.html]

A possible answer here using Address Book:
http://discussions.apple.com/thread....61280&tstart=0

Here's one way to complete the task using an AppleScript Studio App (connects to Apple Address Book):
http://www.macupdate.com/info.php/id/11731/mailmergeapp

Or you can export a csv or excel file and use Office for the Mac and mail merge there.

rosscopeco - Dec 5, 2007 - 3:15 am

Thanks, I'll try this when I get home tonight and get back to you.

Natobasso - Dec 5, 2007 - 1:37 pm

Ok.

rosscopeco - Dec 5, 2007 - 3:03 pm

OK I've now followed all the instructions laid out in the above threads....however after creating the .csv file and going through the import steps in Address book, when I click the 'OK' tab in TEXT FILE IMPORT pop up box nothing happens? I've tried everything I can think of but every time I press the OK tab it just doesn't do anything?

Natobasso - Dec 5, 2007 - 4:05 pm

Make sure your csv corresponds with Address Book's fields.

Did you check Address Book to see if import was successful? Look for one of your csv entries...