Tuesday , December 1 2020
Home / CorelDraw / Creating a Print Merge from A Windows Doc File Part 2

Creating a Print Merge from A Windows Doc File Part 2

I had a request from a seminar attendee on giving them some guidance on working with customer supplied .doc files.
Here is the question: As per our discussion I have attached one of the files I am presently working with. The customer is requesting 1/2 inch letters on a 3/4 x 3 inch stainless steel cable tag.  Here is what I have been doing.  I take the list from windows and copy and paste it onto an an excel spread sheet. When I have the numbers (first column in red) in excel I set my font size.  I then highlight the column or columns and press the down arrow by “copy” and “save as picture”.  Then I paste it to my Corel work sheet, unlock it and then as I can transfer each number to a  cable tag I set the width to 2.1 inches and the letter height is already good.  I am printing approximately 150 tags x 2 for nineteen different jobs with one letter changed i.e.:  JA-HRTD-LHIC04A-1  only the letter in red would be changed for each of the nineteen jobs i.e.; A,B,C, etc.

Here is Our Intro Screen

media_1439571594604-1.png

Here is the introduction screen click “import text from a file or an ODBC data source” (1).

Select ODBC Data Source

media_1439571732497-1.png

Select the ODBC Data Source radio button (1). Click on Select ODBC Data Source (2)

Select Machine Data Source and Excel Files

media_1439571898444-1.png

The File Data Source tab is open by default. First click on the Machine Data Source (1). Next select Excel Files (2) by double clicking on the text.

Select The File You Need

media_1439571943639-1.png

When you double click on the Excel Files you will have an explorer window come up. Navigate to the folder where the file is. Select it (1) and click on OK (2).

Our Excel File Contains 1 Field called “Cable Numbers”

media_1439571967927-1.png

An informative window comes up which shows us that there is one field called CABLE NUMBER (1) and one sheet.

Our Wizard Comes Back

media_1439572001760-1.png

We come back to our Wizard Click Next.

Our Field Name

media_1439572073528-1.png

We have a Field called Cable Number (1). Click Next.

Here is Our Imported Data

media_1439572271161-1.png

Our Data from the Excel File is imported into the Wizard. Click Next

Our Print Merge Toolbar Opens Up

media_1439572308543-1.png

Once we exit the wizard we are given a floating toolbar (1). Notice that the Cable Number is listed in the Pull Down box (2). Click on the Insert button (3)

We Have a Merge Field

media_1439572362918-1.png

Once we click on the Insert button a merge field comes into the page. We know it is a merge field as it is encompassed by a less than figure and a greater than figure (1).

Format Your Print Merge Text

media_1439572391130-1.png

Before we do our print merge we need to format our text so that it is as we need it to be in the job. This job calls for text that is .5 inches tall and the text that is arial. I have resized the text to .5 inches (1).

Make Your Text Center Justified

media_1439572438105-1.png

Because words are all different lengths we need to make sure that our text is center justified. Select the Justification drop down (1) from the property bar.

Merge Our Excel File to a New Document

media_1439572485531-1.png

To merge our text file into CorelDraw we need to click on the :”Merge to New Document” (1). button. What this command does is take each line from the Excel file and create a new plate. Each plate becomes a new page in our job. We thus end up with a job that has a bunch of pages. If our text file is 182 names we get 182 pages.

Corel Creates a Separate File

media_1439572512734-1.png

When we do our print merge Corel creates a separate file called PrintMerge1. This file holds all the pages with the names on each page. Note: It is good practice that we save this file as it holds all the names from the Excel file. The above figure shows the PrintMerge1 file is open the “unititled-1” is the original file.

I Have Created 128 Pages

media_1439572557174-1.png

There where 128 names in the original text file and we have created 128 pages (1) with names on it.

Condense Each Line

media_1439572592142-1.png

We need to condense each line so that it fits on the plate. We need to check each line to make sure they fit on the plate. Note: in future article I will show you how to automatically condense this text.

Select the Print Command

media_1439572648700-1.png

We now need to print our names that we have created with the print merge.

Select Your Laser Driver

media_1439572693726-1.png

Select your laser driver (1). Next click on preferences (2)

Adjust Your Settings

media_1439572982414-1.png

Adjust your power, speed etc for the job. Make your plate size 24 by 12

Click on the Layout Tab

media_1439573156019-1.png

We now need to select the layout tab (1).

Select the Imposition Layout

media_1439573095375-1.png

We will now use the Imposition Command to create our multiple plate. Select the “Edit” button (1).

Type Your Desired Number of Rows and Columns

media_1439573211579-1.png

We now need to tell the program how many plates we want across and down. You can see that I have 8 across (24 / 3) Do not exceed this (if you put in 9 it will make your plates smaller) and 12 down. I could have done 16 down (12 / .75) (1).

Our Multiple Plates are Done

media_1439573248921-1.png

You can see that the I have created 128 plates. By default you do not see the text on the plates just a gray overlay. We have an issue here as my plates are not at the top left corner of our page.

Move Our Plates to the Top Left Corner

media_1439573292486.png

By default because our plates do not fill up the multiple plate they work from the middle and we have have a large top margin. We can get rid of this margin by clicking on the “Edit Basic Settings” (1). Select Edit Margins.

Click on the “No Margins” button

media_1439573403509.png

Click on the to move our margin to the top of the page

Our Pages Are Now at the Top

media_1439573456697.png

Now that our pages are at the top we can preview the page by selecting Edit Basic Settings (1) and click on the preview button (2)

Our Preview Shows us the Job is ready to Go

media_1439573482029.png

The job is ready to go other than I did not condense the all the text (1). When you are done click on the Check Mark (2) to exit out. You can send the job now to the laser. Note: I only condensed the first plate so that it fits on the plate. The rest of the text is beyond the plate and thus is cut off.

About admin

Check Also

Laser Engraving Photos On Acrylic

In this video we will show you how to to take a photo and laser …

Leave a Reply

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