Friday , May 7 2021
Home / CorelDraw / Print Merge / Doing a Print Merge in CorelDraw of 20 Lines Per Plate Using an Excel File Part 1

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

This is a file that was given to me by one of my customers who needed some help in the print merge. The original file I got had all the lines in one column so I suggested that the customer fix it up so that there were 20 columns of names.

Create a New Page in CorelDraw

media_1282836144053-2.png

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).

Open the file in Excel

media_1282831424260-2.png

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.

Excel File Close Up

media_1282831572542-2.png

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.

Open Print Merge

media_1282833086676-2.png

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

Select Import Text

media_1282833118865-2.png

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

Select OBDC Data Source

media_1282833153014-2.png

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

Select the Excel File

media_1282833191025-2.png

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

Select Your Excel File

media_1282833215590-2.png

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.

Review the Fields

media_1282833259593-2.png

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

media_1282833270223-2.png

Select Next (1)

Review Your Fields

media_1282833300335-2.png

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

Review The Imported Text

media_1282833310086-2.png

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

media_1282833317585-2.png

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

The Print Merge Toolbar Becomes Active

media_1282833354178-2.png

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).

About admin

Check Also

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

This is a file that was given to me by one of my customers who …

Leave a Reply

Your email address will not be published. Required fields are marked *