6 Replies Latest reply: Nov 21, 2007 3:33 PM by Dancin' Brook
sawsaw Level 1 Level 1 (0 points)
I have made a letter with Pages'08, and I have to print-out and give to about 1000 people.
But I want to add the name of each people at the header of the letter and those name I have save in a Numbers'08 file.

Is there any ways to merge the data in the Numbers file to the Pages file?

I only know i can copy n paste 1000 times...

iMac, Mac OS X (10.4.10)
  • Sagesse Level 5 Level 5 (6,685 points)
    My understanding is that Pages can only merge with the Addressbook application.
  • sawsaw Level 1 Level 1 (0 points)
    It means that I have to put all the names to AddressBook first, then merge with Pages?
  • Badunit Level 6 Level 6 (11,400 points)
    It does appear that it can only merge contact info from the address book. You should be able to import the required data to the address book by first exporting it to a comma-separated value file. Here's what the help section for Address Book says followed by the export section of the Numbers user's manual:

    Address Book can import address information in the following formats:


    vCard

    LDIF format

    tab-delimited file

    comma-separated values (CSV) file
    To import contact information from another application, you need to save or export a file in one of these formats. You can export addresses in LDIF format from Netscape, and vCards from Palm desktop, Entourage, Outlook, and others.

    Most databases allow you to export text files in tab-delimited or CSV format. Address Book uses field labels in text files to know how to import the information into your address book. For example, Address Book uses the label "Last name" to match up that field in the imported text file with the "Last name" field in your card template. (If your database doesn’t include labels in the exported file, you can manually identify the information fields while importing the file into Address Book.)

    To identify the kind of file you are trying to import, select the document and choose File > Get Info. Before importing a .txt or .cvs file, verify that the file does not contain line breaks, which might cause the import to fail. You can use any text editing application to find and remove line breaks.


    To import addresses from other applications:
    Export your addresses from the other application in one of the formats supported by Address Book.
    When exporting a tab-delimited or CSV file, you may want to write down the order of the information fields. This will help you in step 4 if the exported file doesn’t contain labels.

    In Address Book, choose File > Import and choose the format of the exported file from the submenu. Choose "Text file" for a tab-delimited or CSV file.
    Select the file that contains the exported addresses.
    If you are importing a text file, use the pop-up menus in the Text File Import dialog that appears to specify how to import the data.
    If the first record contains labels instead of information for a contact, select the "Ignore first card" checkbox.

    Use the left and right arrows to see different records in the file you're importing. This helps you determine how to set the pop-up menus. If you don't want to import a field, set the pop-up menu to "Do not import."

    To set the pop-up menus for address fields, choose the type of address (home, work, or other) in the pop-up menu next to the first item of the address. Then use the address pop-up menus that appear to choose the corresponding data for each address field.


    To import many addresses at once, create a vCard that has multiple contacts (if the other application supports it).

    When exporting data from Palm Desktop, use the default column layout.

    To see the last batch of addresses you added to Address Book, click Last Import in the Group column. The list of most recently imported addresses will be updated the next time you import addresses. Use the View menu to show or hide the Last Import item in the Group column.

    You can also use iSync to import contacts from your Palm device. For more information, open iSync and search iSync help for "Palm."

    ---

    Exporting to Other Document Formats
    You can share your Numbers spreadsheets across different platforms by exporting
    them to a file in Excel, PDF, or comma-separated values (CSV) format.
    To export a spreadsheet to another file format:
    1 Choose File > Export.
    2 Choose a document format.
    PDF: PDF files can be created using an image quality of good, better, or best. They can
    be viewed or printed in Preview, viewed or printed in Safari, and edited with a PDF
    application. Choose All Sheets from the Layout pop-up menu to create a PDF that
    shows each sheet on a separate page. Choose Current Sheet from the Layout pop-up
    menu to create a paginated PDF of the selected sheet.
    Excel: These files can be opened and edited in Microsoft Excel on a Mac OS X computer
    or on a Windows computer. Each table is converted to an Excel worksheet, and all other
    objects are placed on separate worksheets if there’s more than one table. Some of the
    formula calculations may differ in Excel.
    CSV: Many spreadsheet applications can open a file in CSV format. In a CSV file, cell
    values in each row are separated using a comma, and rows are separated using an endof-
    line character. Each table is placed in its own CSV file, and all the files are placed in a
    folder. No graphics are exported. The last calculated values are exported.
    3 Click Next.
    4 Type a new name for the document.
    5 Choose where you want to save the document.
    6 Click Export
  • sawsaw Level 1 Level 1 (0 points)
    Exactly what I want, Thanks!
  • Curt Cozad Level 1 Level 1 (5 points)
    Any updates to this problem. I want to merge FileMaker DB files into Numbers and then into a form letter with Pages. Is that possible? I can do it easily with MS Word, but I am really trying to get away from MS products. I don't want to spend the money on iWork when it won't do what I want. I send out letters to 400-500 different people every six months and I don't want them in my Address Book. Any suggestions?
  • Dancin' Brook Level 4 Level 4 (2,015 points)
    Set up another user acct on your mac and put the names in that address book.

    Or put them in a group in your regular address Book and then export as v-cards then delete, and reimport again later.