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
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
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
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
Got to File (1) | Print Merge (2) | Create/Load Merge Fields (3).
Select Import Text
Select “Import text from a file or an ODBC data source” (1). Click next (2)
Select OBDC Data Source
Select “ODBC Data Source” and then select “Select ODBC Data Source”
Select the Excel File
First click on the “Machine Data Source” tab (1). Next double click on the “Excel Files” name (2).
Select Your Excel File
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
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)
Review Your Fields
You can see that the columns are imported (1). The field type is text (2). Click Next (1).
Review The Imported Text
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
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).