Doing a Print Merge in CorelDraw of 20 Lines Per Plate Using an Excel File Part 1

Create a page in CorelDraw that is 6.0 by 3.0. You will notice that I have places some descriptive text at the top of the page (2).

Here is the file my dealer got from their customer. There are 20 columns of names. each Column needs to have a descriptive name. In this case it is NAM01 and so forth.
NOTE: remember that CorelDraw will not condense names. Thus you need to figure out how many letters you can get on a line without the line flowing past the page margins (you could do an envelope so maybe I will address that in another tutorial). So pick your font size and figure out how many characters can go on a line and tell the customer to work within these parameters.

Here is the excel file in close up view. Notice that the first cell has the identifier text NAM01 (1). The text is in the fields below. The next column has the next identifier NAM002 (3). It does not have be NAM01 it can be any descriptive name that you want.
Note: Once the file has been checked close it down.

Got to File (1) | Print Merge (2) | Create/Load Merge Fields (3).

Select “Import text from a file or an ODBC data source” (1). Click next (2)

Select “ODBC Data Source” and then select “Select ODBC Data Source”

First click on the “Machine Data Source” tab (1). Next double click on the “Excel Files” name (2).

Select the directory where the file is (1). In this case My Documents. Next double click on the file name (2) in this case PLTALL.xls. Or click once and click “Ok”. Click next.

The PTALL file is selected (1). The Column window shows the 20 columns that where in excel that are being imported into Corel (2). Select Ok (3).

Select Next (1)

You can see that the columns are imported (1). The field type is text (2). Click Next (1).

Here is the text displayed in the Merge Wizard. You can see the merge fields listed on the top (1). The names are all listed in the body (2). Note: you can spell check or change any of the names here if you want. You can also choose not to bring in a name by unchecking the name name (3). Click Next (4).

Select Finish (1). This will end the wizard.

The print merge toolbar becomes active. We now need to start inserting our merge fields. Our Name field is NAM01 and we are going to insert it onto the CorelDraw document that we created using the insert command (1).