Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Contacts

As a result of a deplorably long and much-regretted history of using a PC, my collection of 500+ names, addresses, &c. is in a table formatted in MS Word.


I repented of that, and about 8 years ago changed to a MacBook using Snow Leopard. With it, I happily created address-labels using MS Office 2004 for Mac, but earlier this year took the step/committed the blunder of upgrading to Mountain Lion, so no more MSO 2004.


As a result, I need now to create address-labels using Avery DesignPro for Mac. I took the precaution of re-formatting the table as a TSV-table in Pages, but ADP seems unable to find and use it ?


Can any kind person help ?

MacBook Air, OS X Mountain Lion

Posted on Dec 23, 2012 11:01 AM

Reply
29 replies

Dec 23, 2012 12:05 PM in response to paieyeagain

I found this on Web page of ADP


Easy-to-use, intuitive Mac user experience. Compatible with Mac OS X 10.4 and 10.5. Quickly import personal photos from iPhoto. The Snapshot Gallery allows you to capture and transfer customized designs and logos onto various projects. Simplify Mailings - effortlessly merge data from Address Book and Mail. Easily import playlists or albums from iTunes onto Media products.


It should be able to use your Addres book.

Dec 23, 2012 12:45 PM in response to paieyeagain

This is the link.


https://discussions.apple.com/thread/3496248?answerId=17345817022#17345817022


I hope you can get some result.


The main point is you can import CSV Files into Contacts, but you have to start with a CSV file which has for each line exactly the same number of "Items" in the right position which they will have into Contacts, creating if necessary empty fields with more commas. I suggest you make some test with a test CSV file with few lines and test the import and the print. Not sure if you can get a CSV Files from Pages. If not you may use Open Office.

The link I send you has some more details but basically is as writter here over.

Dec 23, 2012 1:03 PM in response to paieyeagain

paieyeagain wrote:


I use NeoOffice, which I think is for this purpose the same as OpenOffice. When I open the file and click File, Export, the only choices offered are .html, .pdf, and .txt.


That is because you are opening it in NeoOffices' word processor instead of the spreadsheet module. CSV is a spreadsheet format, can't generate it in a word processor.

Dec 23, 2012 1:15 PM in response to WALTER-MILANO-ITALY

WALTER-MILANO-ITALY wrote:


Why ? You should be able to get a CSV file from Open Officie if yoy start from Pages.

Well he has NeoOffice but your point is still valid, and once the csv exists I would suggest that conversion to Contacts's native format is desirable as it avoids all those header/label issues. Online and free converters from csv to vcard are a dime a dozen (less actually). Using one is the simplest.

Contacts

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.