[private]I just got this in Design Tip in my mailbox which i couldn’t wait to share!.AND why on earth i have not been using Indesign!
TIP: One Business Card, Many Names
Using InDesign’s Data Merge feature can take the tedium out of generating business cards for a company with multiple employees. You design the card as usual and then combine it with a data file prepared in Microsoft Excel that lists the names and other information that changes. In the template card, you place fields for the real information, merge the file with the Data Source, and presto! Your result is a document with as many cards as there are records in the data source.
For step-by-step Data Merge instructions, see “Automate This!” in the April/May 2006 issue (#11), also posted on CreativePro.com.