Skip to main content
peterpica
peterpica
Inspiring
June 15, 2017
Answered

Mail merge

  • June 15, 2017
  • 1 reply
  • 2126 views

Is there a way to create an InDesign (CS6) document that can handle merging data from an Apple Numbers database. I'd like to layout a postcard with address info on one side, and a greeting on reverse side over multiple pages (about 300 fronts & 300 backs)... can the text box on initial page be done so that it will automatically create new pages with the data so that all text blocks are linked? Would like to end up with a print-ready PDF with fronts & backs sequential for duplex printing.

???

Thanks.

    This topic has been closed for replies.
    Correct answer JonathanArias

    David Blatner on lynda.com will show you everything you ever need and want to know about this procedure. i had to do 20,000 certificates, i was provided excell sheets. Exported to CSV files, clean them up with text wrangler, followed Davids instructions and it was a dream.

    you can go a step further and use acrobat to separate the one data merge file into individually name files that match the name on the address.. very cool stuff. here:

    InDesign: Data Merge and Database Publishing

    1 reply

    J
    Community Expert
    Jeffrey_SmithCommunity Expert
    Community Expert
    June 15, 2017

    From Numbers, you need to export a csv file to be used as the source for the data merge.

    In Indesign, to create a merged file that can print front and back, create a new document with facing pages. Place the static front art on one master page, and the variable content on the other master page. When merged, this will create a 600 page document or PDF, alternating front-back-front-back-etc.

    Also, if either of the sides have bleed, you can adjust the layout with the Page Tool to move pages vertically. This will allow bleed, and not have art cross over from one facing page to the other.

    peterpica
    peterpicaAuthor
    Inspiring
    June 15, 2017

    Thanks... but both front & back have variable data. Front address side with variable data; back 'static' message but with a variable address line at top (Attention:..... variable data). Might there be a tutorial for this? I'm new with this merging stuff and not too quick of mind at 74.

    NO bleed.

    JonathanArias
    JonathanAriasCorrect answer
    Legend
    June 15, 2017

    David Blatner on lynda.com will show you everything you ever need and want to know about this procedure. i had to do 20,000 certificates, i was provided excell sheets. Exported to CSV files, clean them up with text wrangler, followed Davids instructions and it was a dream.

    you can go a step further and use acrobat to separate the one data merge file into individually name files that match the name on the address.. very cool stuff. here:

    InDesign: Data Merge and Database Publishing

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices