Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Other Topics > Art & Graphic Design > Addresses Built In to InDesign Document

Addresses Built In to InDesign Document
Thread Tools
Professional Poster
Join Date: Jan 2000
Location: Stoneham, MA, USA
Status: Offline
Reply With Quote
May 25, 2009, 04:34 AM
 
So I figured rather than printing 200 copies of my postcard, then printing 200 address labels and sticking them. It would be wiser to make a 200 page indesign document, with the addresses printed directly on the card. So I'm working on getting my addresses into an excel spreadsheet. But once there, does indesign have a mechanism for importing data like this? Where I can have 200 identical pages, then load different data into one particular box in each page?
(Last edited by l008com; May 25, 2009 at 02:52 PM. (Reason:spelling))
     
Moderator
Join Date: Jun 2000
Location: Inside 128
Status: Offline
Reply With Quote
May 26, 2009, 04:39 PM
 
Where are your addresses now? Why bother with excel?

create one page document with text box on master page set to link.

export addresses as comma/tab separated values, command paste into text box, text will flow to as many pages as needed... select all, search/replace comma/tab for /p or similar, apply paragraph styles, clean up.
     
Professional Poster
Join Date: Jan 2000
Location: Stoneham, MA, USA
Status: Offline
Reply With Quote
May 26, 2009, 05:49 PM
 
That seems like a kind of fragile way to do it? Any address that has one extra return in it, and every address after it will be messed up. And now the addresses are in addressbook.
     
Moderator
Join Date: Jun 2000
Location: Inside 128
Status: Offline
Reply With Quote
May 27, 2009, 09:35 AM
 
Export the addresses from address book as text file then. No need for excel.

Sorry, I mixed up my syntax a little. ^t is tab, ^p is paragraph, ^n is shift return. However your text is exported, you should be able to search and replace to get a paragraph block.

If the box is big enough to handle 4 lines of text, and you set your paragraph style to keep all lines together, the size of the address should not matter, the next address will jump to the next page's text block. Or you could set two styles up with different bottom margins. Once the page is flowed it wouldn't take long to command arrow through it and tag with styles, especially if you set up key commands for the styles.
     
Professional Poster
Join Date: Jan 2000
Location: Stoneham, MA, USA
Status: Offline
Reply With Quote
May 27, 2009, 01:30 PM
 
Also, how do you export to text, from address book?
     
Moderator
Join Date: Jun 2000
Location: Inside 128
Status: Offline
Reply With Quote
May 29, 2009, 10:10 AM
 
     
Fresh-Faced Recruit
Join Date: Jul 2009
Status: Offline
Reply With Quote
Jul 1, 2009, 12:53 PM
 
Hi andi*pandi - I need your help.. I have the same problem but I'm trying to figure out how you make a text box on the master page in INDD and "link" it? I'm sure it is really simple but if you could talk it through for me I'd really appreciate it.

Please PM me if you can help.

THANKS!!!!!!!!!!!
(Last edited by Thorzdad; Jul 1, 2009 at 04:01 PM. (Reason:Never, ever post your email address))
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 11:03 PM.
All contents of these forums © 1995-2009 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.4 © 2000-2009, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2