Skip navigation

Contacts

377 Views 29 Replies Latest reply: Dec 24, 2012 12:34 PM by Csound1 RSS
1 2 Previous Next
paieyeagain Level 1 Level 1 (0 points)
Currently Being Moderated
Dec 23, 2012 11:02 AM

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
  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)
    Currently Being Moderated
    Dec 23, 2012 11:13 AM (in response to paieyeagain)

    Keep the formatting will not be easy.

    Probably the best solution could be to use MSO 2011.  Well it will cost you some money but save time and efforts.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)
    Currently Being Moderated
    Dec 23, 2012 11:57 AM (in response to paieyeagain)

    I undertand your point.

    Let me try some suggestions

    I do not know how ADP works. If it is not able to see Pages, you have to find a different approach.

    Which kind of files can ADP work with ?  Probably TXT os CSV files ?

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)
    Currently Being Moderated
    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.


  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)
    Currently Being Moderated
    Dec 23, 2012 12:31 PM (in response to paieyeagain)

    I see that Contact can print directly Labels which can be also defined according to Avery Standard.

    Now the problem is how to put your data from MS Word into Contacts.

    I remember I had a similar problem some time ago, and my suggestion was working

    Give me half an hour to check in my old posts, And I'll come back to you.

  • Csound1 Level 7 Level 7 (32,385 points)
    Currently Being Moderated
    Dec 23, 2012 12:38 PM (in response to paieyeagain)

    Download Open Office, open your file in the spreadsheet, sort the fields out (it is unlikely they will be perfect) then export it as a .csv file.

     

    Using a converter (many available) convert it to a vcard file and import it to Contacts on your Mac.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)
    Currently Being Moderated
    Dec 23, 2012 12:45 PM (in response to paieyeagain)

    This is the link.

     

    https://discussions.apple.com/message/17345817#17345817

     

    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.

  • Csound1 Level 7 Level 7 (32,385 points)
    Currently Being Moderated
    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.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)
    Currently Being Moderated
    Dec 23, 2012 1:09 PM (in response to paieyeagain)

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

  • Csound1 Level 7 Level 7 (32,385 points)
    Currently Being Moderated
    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.

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.