6 Replies Latest reply on Jun 16, 2017 12:35 PM by peterpica

    Mail merge

    peterpica Level 1

      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.

        • 1. Re: Mail merge
          Jeffrey_Smith Most Valuable Participant

          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.

          • 2. Re: Mail merge
            peterpica Level 1

            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.

            • 3. Re: Mail merge
              JonathanArias Adobe Community Professional

              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

              • 4. Re: Mail merge
                peterpica Level 1

                Holy cow! MUCHOS GRACIAS AMIGO!

                 

                 

                 

                Kindest regards,

                 

                   Peter Stremic, Proprietor

                   PETERPICA Productions

                • 5. Re: Mail merge
                  Jeffrey_Smith Most Valuable Participant

                  Both pages can have variable content, I assumed that the front was static in your situation. In fact, you can have more than 2 pages in the merge master document, and all have variables placeholders on those pages.

                  • 6. Re: Mail merge
                    peterpica Level 1

                    Thanks much all... was easier than I thought it would be.

                     

                    Regards all.