.:++ Me+MySelf & I ++:.

dari dalam diri seorang aku..

Data Merge with InDesign CS2 April 12, 2006

Filed under: Tutorial — asriey @ 11:17 pm

Situation
U have to create certificate for about 130 participant. Do u dare to type/create 130 pages of that certificate?

Solution
U need to have InDesign CS2 and MS Excel installed (never try with openoffice yet).

1- create the template for the certificate.
2-leave a space for Nama and IC number (for example)

3-using shortcut F on keyboard or click at Frame Tool, Click n drag 2 rectangle space for Nama n IC

4-in MS Excel, type the whole Name and IC and save it as Comma Delimited (.CSV)

5-open Data Merge window, Window->Automation->Data Merge, click Select Data Source and choose the .csv file.

6-U will get a window like this.

7-to put it into our frame, press V on keyboard to get select tool, select frame then select the field, for example Nama. Do the same to IC, u get something like this.

8-adjust the type and size of font, position and so on, u can preview live data by click on preview box.
9-finally, click on Create Merge Document.

10-just do something like this, just click Ok and magic happen, 130 page created within a minute.

11-you’re done!
gud luck!

 

One Response to “Data Merge with InDesign CS2”

  1. Randi Says:

    This was very handy to look through the steps. I’m glad I came across your page.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s