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. Search for jobs related to Excel data merge script indesign or hire on the worlds largest freelancing marketplace with 19m+ jobs. 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. Step 7 From here, find the member.txt file you made earlier and click Open. Click the hamburger icon on the Data Merge panel and choose Select Data Source. Advertisement Step 6 Next, we need to attach our data to the document. You can find this under Window > Utilities > Data Merge. 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. To use the merge features, we will need the Data Merge panel. (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.