

The final bottom fixed panel was placed as an anchored object with Bottom text frame with auto height applied allowing the panel to stretch to fit if needed. The taller final text frame was allowed to automatically resize its height, so to buffer and fill any space in the column left over. These frames were designed to flow between the three columns. Inside the master three column text frame was placed 34 individual Anchored text frames, each with a minimum 5mm height to keep size consistency and auto height applied to allow the frame to resize for two line company names. This text frame was set to “Balance columns”, meaning the items placed inside would automatically balance visually. It contained a three column text frame on the only page. The data merge was the more simple part of this project.Ī master InDesign single page document was created for the data merge master. Single Excel sheet calling data from 125 sheets, ready to export to InDesign for Data merge. These were saved as CSV for export into InDesign using data merge.Įxample of random and static names – bottom five will be static (highlighted) on each sheet.Ģ9 randomized names with five added static names.Įxcel document with company names, randomized to 125 data sheets. Eight files of randomized names were produced in total.Each sheet would equal one InDesign page. Excel itself has a sheet size limit, so to keep processing time down and stay with in the Excel limit, we spit each set of 500 cards into 4 documents of 125 sheets of 34 randomized companies.All these ! (exclamation mark) prefixed firms were to be the highlighted businesses. The Five static company names were added into the single list, each prefixed with an ! (exclamation mark).The Excel was also built to added a – (hyphen) in front of the remaining 24. The Excel document also Added an ! (exclamation mark) in front of five of the company names. I created an Excel document that took a list of 29 companies, and randomized the order of these companies.Select File > Export to save it as a multi-page PDF. You can scroll through the addresses using the arrows for a quick peek.Īnd for the grand finale, select ‘create merged document.’ Now you have all the addresses in one document, you creative genius, you!įor printing, you’ll want to export your new PDF. Boom! Problem solved.Ĭheck ‘preview’ to see how it looks. Tip: Some addresses only have one address line instead of two? To get rid of that pesky extra space when there is no entry in the optional Address Line 2, click on the little hamburger menu in the panel (the same one where you found ‘select data source’) and hit Content placement options > remove lines that are blank. When you’re finished, it will look a little something like this. These column titles become “placeholders” for your addresses. I like to this by highlighting the text and replacing it with the corresponding column name. Place them on the document by clicking on them where you would like them to appear.(Oh, and you also get a little handy-dandy "how to" right in the panel!) csv file (Name, Address Line 1, etc.) will show up. Click “select data source” and select your.

Click on the little hamburger menu in the top right corner of the panel that pops up.This is where you’ll set up your font, color, spacing, placement, etc.

Once you have your “envelope,” go ahead and open up a text box and type in an address the way you’d like the rest to be formatted. Step 2: Create a new document that’s the size of your envelope in Adobe InDesign. Tip: I also use this add-on (shown below) to format the addresses to all caps or all lowercase if my design calls for it.
Indesign data merge excel download#
I keep it simple: Name, Address Line 1, Address Line 2, City, State, and Zip, but feel free to add whatever you want! Then download it as. (That way my bride can easily edit it and no back-and-forth-files that leave room for error.) Make sure each column is clearly named. csv file.Įxcel may be the obvious choice here, but I use Google Sheets. Step 1: Create a spreadsheet with the addresses and download it as a. Here’s how you can set up data merge in Adobe InDesign for your wedding clients’ guest addresses. Lucky for me (and my poor fingers), setting up data merge for variable guest address printing is a breeze and well worth the extra few clicks. Setting up my client’s envelopes for wedding guest addressing always seemed like the hardest task, and at the beginning of my biz, I honestly thought I would rather hand-calligraph each one than figure it out.
