Previous 1 2 Next 28 Replies Latest reply: Dec 24, 2012 12:26 PM by WALTER-MILANO-ITALY
paieyeagain Level 1 Level 1 (0 points)

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)

    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.

  • paieyeagain Level 1 Level 1 (0 points)

    Thank you, but I was hoping by time and efforts to make up for my lack of money.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    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)

    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.


  • paieyeagain Level 1 Level 1 (0 points)

    ADP can certainly work with Contacts, but my difficulty is to get the material in my MS Word table into Contacts.  So far as ADP claims to be able to do more than that, I can say only that my experience is to the contrary.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    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.

  • paieyeagain Level 1 Level 1 (0 points)

    Thank you for this, much appreciated !

  • Csound1 Level 8 Level 8 (44,250 points)

    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)

    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.

  • paieyeagain Level 1 Level 1 (0 points)

    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.

  • paieyeagain Level 1 Level 1 (0 points)

    The difficulty with that link, Walter, is that it presupposes that one has Outlook.

  • Csound1 Level 8 Level 8 (44,250 points)

    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)

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

  • Csound1 Level 8 Level 8 (44,250 points)

    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.

Previous 1 2 Next