7/30/2023 0 Comments Indesign data merge bottom justify![]() ![]() You might want to keep your text in the default format for a moment (columns separated by a tab, rows ending with a hard return). Then you can copy/paste your text into indesign. When you've got all your fields sorted, delete the original, unformatted columns. Then you have to copy/paste special and remove the "formula" from the new column. If you want one of your lines to read "Phone: #-#-#" then make a column next to your phone numbers column, and use it to build a "display" version of your column. Put everything in order from left to right, and make sure you get EVERYTHING that you want shown. It really depends on what your specific dataset contains, how it is formatted, and what you want it to look like in the end.īasically, you probably want to take your spreadsheet and organize it with the thought that every "entry" in your layout equals one row of the spreadsheet. ![]() What is your page size? Also, take all the items in your template page (I'm guessing from your description that there's only 1 text box with 2 columns.) and tell us what those dimensions are. It's sort of trial-and-error until you get the fitting that you want. You have to use your imagination a little bit with multiple record merges, because indesign doesn't give any visual clues as to the structure you are creating. If attachments weren't blocked right now you could just upload a sample for us to see. Make your text boxes as small as possible. Make your margins very very small and try again. 5 inch spacing across the board, you wouldn't be able to fit 2 records on a 5x5 inch document page, so each entry would be pushed to the next page. For example, if you have 4 text boxes per entry, and they are in a 1 inch square grid, and your "multiple records per page" settings have. If so, consider if you're leaving enough room on the page for multiple instances of all the objects on your document. ![]() ![]() Now all my text frames expand from the top right to fit all the text for each data field on the one line without spilling over to the next.Does your data look correct when you do click the "preview" button? In this case, I chose to resize from the top right corner, and selected the option for “No Line Breaks.” Select the text frame with the Address Fields, and then you can go to Object > Text Frame Options. InDesign has a great feature to combat this, which was introduced in CS6: Auto-Size. So I need to come up with a solution that fixes the overset text problem and keeps each data field on one line. In this case, the overset happened because my text frame was not large enough. If there is overset text, each example is noted. When you export to PDF, InDesign creates a report. Usually your Data Merge will look something like this: InDesign will inform you of overset text, but only after the merge is complete!įrom the flyout menu in the Data Merge panel select “Export to PDF.” Problems like these can be hard to notice, especially when you’re working with a database of 10,000 addresses! It would be very difficult and time consuming to proof the output and fix any mistakes you find. But it’s missing because the text frame is overset.Īnd in this example, the text “Andrew Young International Boulevard” should appear on one line, not two. You can see the problem in the screenshot below – the text “United States of America” should appear at the bottom of the address. Recently, I came across a trick that I thought was worth sharing. My particular problem was that the text frame wasn’t big enough for a long field in my data merge. Fortunately, there are plenty of good data merge tips here at InDesignSecrets and at. Using InDesign’s Data Merge features can be tricky at times. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |