![indesign data merge hangs indesign data merge hangs](https://community.adobe.com/legacyfs/online/202487_Data+Merge+6.png)
Using a text editor, replace the word “move” with a tab, and this eliminates having to type tabs in the text frame that will act as a slingshot to move/hide text off of the active page Using a CSV file instead of a TXT file.Using GREP styles to make the word “move” become large enough to move the type without requiring the tabs.The technique I’ve used to move the relevant artwork on or off the active page is a simple method that doesn’t require any GREP styles or JavaScripts, but other techniques could be employed, such as: From here, you should now see that the layouts are swapping based on the information from the database.įor the sake of the example I’ve only used three layouts but using this technique it is possible to add as many as you like. Once done, make all layers visible and toggle through the Data Merge records. Repeat this process for the remaining two layers. Click and drag the square onto the end of the text that was just created.Ĭlick on the square to open Anchored Object Options and change the position so that the Anchored Object Reference Point is the top left, the Anchored Position for the X Relative is to the Anchor Marker with 0 offset, and the Anchored Position for the Y Relative is to the Text Frame with 0 offset, and its reference point is to the top left. Next, click on the grouped layout so that the Anchored Object Control (the little blue square) is visible. In this example, because the Canada layer is visible, I will replace the word “move” with the Data Merge field “Canada”. Highlight the word “move” and replace it with a Data Merge field that is to act as a trigger for that layer. Place a tab stop in the center of the word “move” and then another tab stop at the left bleed margin. In this text frame, type the word “move” followed by a tab, and show the document tabs. With only one of the layers visible, create a text frame that starts at the top of the bleed edge and as close to the left edge of the pasteboard as possible, and ends with a small portion of the text on the text frame – it is important that part of the text frame is on the page or the technique will not work. In this example, I’m working to a DL size of 99mm high × 210mm wide, so I want the horizontal margin to be wider than 210mm, so 260mm will be plenty. When creating the document, in the Guides & Pasteboard section of the Preferences dialog box, be sure to adjust the horizontal margins value so that it is wider than the artwork. Group the artwork on that layer, and then create another layer for the second travel destination, repeating this process until all three destinations are prepared and grouped on their own layers.
![indesign data merge hangs indesign data merge hangs](https://3v6x691yvn532gp2411ezrib-wpengine.netdna-ssl.com/wp-content/uploads/2019/07/MergeVenn-300x180.png)
The database above will need to be exported as a tab-delimited text file so InDesign can perform a Data Merge.īack in InDesign, create a layer for the first travel destination, and then prepare the layout as desired along with the relevant Data Merge fields. It is also important to point out that this technique doesn’t invoke some hidden Data Merge ability involving layers, but instead shows or hides content based upon the trigger in the Excel file. If it is a match, the statement returns the word “move,” otherwise nothing is returned and a blank space is left. The original database in Microsoft Excel contains a column that has the prospects’ destination and also has three columns to the right of it that use an if statement to determine if the copy in the destination column is a match for the column heading. The key here is inside the database that will be used for the Data Merge. But what if I told you it was possible to do this using one database with one InDesign file? Well, it can be done! How this technique works The way I would imagine that most people would tackle this task is to make three postcards in InDesign, separate the prospect list into three different databases and prepare the three Data Merges separately. For the sake of this example, it will be Canada, Europe, or Australia, and the layouts will differ from each other, not just the picture in the background. To tailor the postcards to each prospect, the front of each postcard will have a layout based on the destination that the prospects indicated they’d like to travel to. Take the following example: A travel agent is preparing follow-up postcards based on information it received from prospects during a travel expo. In this post, I’d like to demonstrate another technique that shouldn’t be possible, and that is changing a layout during a Data Merge.
![indesign data merge hangs indesign data merge hangs](https://cdn.shopify.com/s/files/1/0066/9525/6182/files/how_to_set_up_data_merge_in_indesign_for_printing_wedding_guest_address_envelopes_Cami_Monet_Watercolor_Brush_Calligraphy_envelope_addressing_1024x1024.png)
I like to try and make Adobe InDesign’s Data Merge perform tasks that shouldn’t be possible, such as heat maps, bar graphs, and changing colours.