CorelDRAW Graphics Suite X6 :: Print Merge NOT Recognizing Numeric Field From Excel File

Jun 1, 2012

I am having an issue with X6's print merge not recognizing a properly formatted numeric filed from my Excel spreadsheet.  My first issue was that Corel was adding a decimal point after my numbers. This was when they were still formatted as text fields.  (which i still don't understand why, since they were just TEXT fileds) 

I know that the fields need to be "numeric" fields. 

FYI i have ALREADY COMPLETED MY TASK by using an "added" numeric filed that i added IN CorelDraw and then used the "Numeric Field Options" at the bottom of the page to get my number sequence.

However, that is not my question.... my question is: How do i get corel to RECOGNIZE a numeric field AS a numeric field in the first place.

View 2 Replies


CorelDRAW X5 :: Save A Print Merge File With Merge Data Field

Feb 26, 2013

Why cant I save a cdr job with all the merge fields setup so that next time I open the file I can go straight to 'merge to new document'.

So Ive set up a 10 to view raffle tickets job.  Inserted 20 numerical merge fields, positioned, resized, applied font size color alignment etc etc etc.. Takes ages.....  So then merge to a new document, works nice and I can save it fine. 

There are a hundred reasons why i may have to close the 'master' merge file before the job has been successfully printed.  It may be a repeat print job.

Any which way I really dont get why the live merge data  fields are lost on closing the file.

View 3 Replies View Related

CorelDRAW Graphics Suite X6 :: 64 Bit Print Merge

Jun 22, 2013

I have to make print merge firelds in CDX6.

The problem is that I have not Excel on my PC. Only Open office. I create a csv file but Open Office asks me every time what the Field and Text delimiter have to be - for the Field "," ";" ":" "tab" or "space" and for the Text " or '. After that it asks me to check or not few check boxes. See the picture below.

I tryed few combinations but the same result - Failed to save print merge data!

I dont know what to chek but the biggest problem is that I tryed to save a txt tab delimited on other computer with excel and when I try to print merge after loading the txt file Corel says Failed to save print merge data.

I saw that we can Print merge directly from xls files but I cant find that option in ODCB Data Source. Weird! because I have to do 1100 badjes with different merge fields like country, name, code etc... and if I start to make them by hand it will be forever!

View 7 Replies View Related

CorelDRAW Graphics Suite X5 :: Print Merge Numbering

Dec 19, 2011

I created a list if voucher numbering from 1001 to 1200, but when I perform the Print Merge, the list shown are with one decimal point i.e. 1001.0, 1002.0, etc....

What is the reason for this?

View 4 Replies View Related

CorelDRAW Graphics Suite X5 :: Crashes When Doing Print Merge?

Apr 7, 2011

I have just ugraded 4 computers to X5 (one w7, 3 with XP) and are having a lot of problems with the application crashing or hanging. Applies to all computers. We do a lot of print merges, more than 100 a day. Happens randomly, but mainly after several jobs have been printed (jobs, 5-10, still open in X5 in case som modifications are needed).

View 3 Replies View Related

CorelDRAW Graphics Suite X6 :: Imposition And Print Merge

Jun 28, 2012


since i upgraded to X6 i cannot do imposition anymore, using print merge. 

Before i set a page with lets say A5 with the layout, and then in the print merge, i would put 4up (four A5), and it went well, using (collate and cut as well). 

Now look at my attached file, the first page stays different size.

View 11 Replies View Related

CorelDRAW Graphics Suite X6 :: Print Merge Error

Sep 14, 2012

I just installed X6 64bits on my new Windows 7 64 bits machine, so far so good.

But when I try to use the Print Merge wizard, I get this error at the stage where I want to import the lost from an Excel sheet:

View 12 Replies View Related

CorelDRAW Graphics Suite X6 :: Print Merge And Bar Code

Dec 15, 2012

I need to prepare the artwork for 1000 member cards with the membership number present as a barcode. How can I generate the barcode for each individual card without doing it one by one?

View 14 Replies View Related

CorelDRAW Graphics Suite X5 :: Unable To Use Print Merge Option?

Apr 22, 2011

While using print merge option Corel Draw X5 give me an error when I try to import an existing csv or txt file on the print merge dialog box. It says "Impossible to open the file or not correct file format". The files are made with open office or microsoft works, and in the past I've already used and worked good. Now I find this error...

View 4 Replies View Related

CorelDRAW Graphics Suite X3 :: Print Merge With Formatting Options

Dec 5, 2012

I am using CorelDraw to create price labels for my store.  When I merge in the price field for an item I want it to show on the label with the cents in superscript as opposed to using a decimal and full sized cents text.  Is this possible in any version of CorelDraw using the print merge feature?

Keep in mind that I also have the price field in an envelope so that the price takes up the full size allotted on the label whether the price is $1.99 or $999.99.

View 6 Replies View Related

CorelDRAW Graphics Suite X5 :: 4 Print Merge Fields In Same Document

May 23, 2011

I have a document, where I need to have 4 different print merge fields from 4 different data sources (.txt).I can only make it work with 1 print merge field.

View 5 Replies View Related

CorelDRAW Graphics Suite X6 :: Printing Options Not Saved With Print Merge?

Nov 23, 2012

Whenever I perform a PrintMerge the print dialog and its options are reset everytime I leave the print dialog.

Usually you hit print set parameters and hit apply, you now can cancel the dialog and hit print again, your previous settings should still be there. Same goes if you actually print and want to repeat the print process, as long as you dont close the document. This works for normal printing but fails with print merge.

Every time I close the dialog (not the document) all the settings are back to default. This did not happen in X5 and is very annoying since it resets to default even if you actually hit print, forcing you to set the parameters every time.

View 4 Replies View Related

CorelDRAW Graphics Suite X5 :: Print Merge Large Files Without Crashing Or Having To Break It Into Digestible Bits

Aug 3, 2011

Just a guess but with 64 bit Coreldraw maybe we would be able to Print Merge large files without crashing or having to break it into digestible bits.

Do vector conversion of complex images.Use Coreldraw like a publishing program,  - kick Indesign

Computer memory is no longer the issue - 32 bit computer programs are.Until then I will stay with X4. run in Windows 7, 64 bit with 12 Gigs RAM.

View 1 Replies View Related

CorelDRAW Graphics Suite X6 :: Extract Text From File To TXT File In Another Editor And Then Merge

Dec 7, 2012

I´m trying to extract text from a Corel file to a TXT file in another editor and then merge it back in.Extracting the text seems to be working just fine but when I´m trying to merge it back in I get the error message "Wrong file format or could not open".

View 2 Replies View Related

CorelDRAW X5 :: Print Merge With Excel Database

Apr 17, 2011

A1 field name  is FIRST NAME  B1 is LAST NAME   C1 is ADDRESS    D1 is CITY    E1 is STATE

F1  is ZIP   H1 is name1   I1 is name 2       Fields H1 & I1 could not be inserted.

I entered the above field labels and loaded them with the saved Excel file saved as a CSV (Comma Delimited)

When the First names and last names appear in a document there is too big of a space between the first and last names. The same problem happens when I put city, state, and zip on the same line

in the document.

I  did a concatenate combining A1 &B1  to eliminate the space problem and a concatenate to combine D!, E1, and f1 Fields on one line.     I put the results of the concatenates in seperate columns  H1 & I1 but these 2 column fields could not be inserted for the print merge.

How i can solve the space problem between first and last names and the problem to put city, state and zip on the same line with proper space and punctuation.

View 6 Replies View Related

CorelDRAW Graphics Suite X5 :: Variable Data / Merge File Stacked Text

Sep 7, 2012

I am attempting to create a tag system that will have a 5 digit number but must be printed as shown below






We have to create a file to be engraved that has 2000 consecutive numbers and we cannot figure out how to make them appear stacked using the merge feature.

View 4 Replies View Related

CorelDRAW Graphics Suite X5 :: Dynamically Connect Text To Excel File?

Jun 21, 2011

I am building a big catalog for hundreds of products, and it would be a life savior if i could connect dynamically the (customized) text (fields) in the .cdr file to an external excel file data. For example smth like the text field "Title" to be taking its values from the column "Description" of the excel file, incrementally as each line of the excel file could represent a record.  This way also when the excel file changes, (because it will be probably like 10 more versions before it gets final), the content inside the corel draw file will change automatically as well.

Download sample corel file here :


 and sample excel file here :


How to accomplish smth like that or even faster / simpler ......

View 2 Replies View Related

CorelDRAW Graphics Suite X5 :: Print Merge Documents - Many To One Relationships To Flow From Page To Page

Feb 10, 2013

Use merge for standard things like labels.Have a large ongoing project which requires

Lots of Excel data - eg: 6685.excel example.tifcolumns x AZrows x 300 upwards

All rows required to create a book of running information.

If I use a label type approach some rows  have less data making the layout uneven (unsuitable for the project)

Is there a way to merge with a fluid result ?

Ie row one takes up 2 lines Row 2 takes up 5 lines Row 3 takes up 1 line etc 

0728.excel example.tif

View 10 Replies View Related

CorelDRAW Graphics Suite 12 :: How To Link Number In Artwork To External Excel File

Nov 16, 2012

Is it possible to do such a thing? Everyday I have to change the production number in the label artwork. Can I link this production number in the artwork to an external file such as an Excel datasheet?

View 3 Replies View Related

CorelDRAW Graphics Suite X6 :: PDF's With Grid Lines And CD Not Recognizing Photo Paint

Aug 21, 2012

We upgraded to x6.1 and are having some issues. I have X5 and X6 installed on my machine. When using X6 and you add a new page to the document, then publish a PDF. The PDF will show grid lines on the new pages. This happens with new docs and previously created docs when we add new pages. Also, on the new pages, you can't disable the printing in the object manager. 

Second problem, when you have a bitmap in your document and click on it, Photo Paint is available. Only the trace option. Edit Bitmap is grayed out on the Property Bar and not available when you right click the image. I have to open Photo Paint and copy the image into it. There are three of us having the same problems. 


Win 7 Pro 64-bit SP1Platform version:6.1Platform build number:7601Platform info:Service Pack 1

View 5 Replies View Related

CorelDRAW Graphics Suite X5 :: If File Is 11MB Would Print File Be 90MB

May 20, 2011

Why, if a file is 11MB, would the print file be 90MB?

View 10 Replies View Related

CorelDRAW Graphics Suite X5 :: Can't Activate PPD File In Print Dialog

Jan 5, 2012

CorelDraw X5 (German Version've installed Corel X5 under Windows 7 Ultimate 64 Bit.

When I try to set up my ppd-file in the printer dialog window, I can chose the ppd-file but the OK-button (öffnen) doesn't work. Clicking by mouse or by Enter button at the keyboard: nothing happens, the ppd-file won't be accepted. It seams the OK-button is out of any function in this window.

View 2 Replies View Related

CorelDRAW Graphics Suite X6 :: Unable To Print File With White Box And Transparency Lens

Nov 28, 2012

I have a file set up that has a white box with a 65% transparency lens.  When I go to print, the white box and what's under it disappear and do not print.  If I close the document and reopen it, the transparent box and what under it are back.

What do I need to do so this doesn't happen?

View 10 Replies View Related

CorelDRAW Graphics Suite X6 :: Move Guideline With Field Y?

Oct 23, 2012

I try to move a guideline with the field Y for example.1-)  Put a guideline in the page2-)  I need to put my guideline exactly to:  Y: 5.181''.So, I put in the Y field 5.181''.  The bug result is that the field makes an addition.If the position of the guideline is Y: 4.0'', and I want to move it to Y: 5.181'':the guideline go directly to Y: 9.181''.Another question:What is the use of the Object Origin button's options for the guidelines?

View 3 Replies View Related

CorelDRAW Graphics Suite X6 :: Toolbar Edit Field

Sep 24, 2012

Whenever I try to enter a value into one of the CorelDRAW X6 toolbar edit fields, then moving the mouse pointer away from the toolbar in order to see what I'm about to enter, CorelDRAW X6 takes the focus away from that edit field.See her for an example to reproduce the problem:

var video_8143bd82692c4abebed036cbf4afd70b = new jeroenwijering.Player(document.getElementById('video_8143bd82-692c-4abe-bed0-36cbf4afd70b'), URL.....

View 1 Replies View Related

CorelDRAW Graphics Suite X5 :: Merge 2 Files

Jun 30, 2011

I need to merge several Corel Draw files into one Corel file but have no clue how to do this.

View 1 Replies View Related

CorelDRAW Graphics Suite X5 :: How To Merge Layers

Mar 14, 2011

so, for some reason when i choose the body of this cow i drew to fill, it fills its hind leg, and stubbornly refuses to fill the body at all. i have tried all the fill tools to get this too work. i figure if i flatten the image the fill tool will work a bit better. 

there is no such thing as flattening the image or merging layers in the help section and the info online hasn't been so great. How do you merge layers?

View 14 Replies View Related

CorelDRAW Graphics Suite X5 :: Creating American Football Field From Scratch?

Mar 12, 2012

Any tutorial or anything about creating something like a football field from scratch? Or is it better to trace an image of one first? etc..?

View 3 Replies View Related

CorelDRAW Graphics Suite X4 :: Text Constraints When Using Merge

Oct 2, 2012

Using x4.  I am looking to merge a list of names into a matrix and maintain text constraints.  I want all the names to fit into a certain space (ex. 1.5" long) and to maintain a certain character height (ex. .25" high).  So my output should be no longer than 1.5" and all should have .25" high characters on a single line.  I am able to setup the template and lock the fields, but during the merge everything gets messed up.  All x, y positions, text length and text height have to be manually reentered for each name. 

View 1 Replies View Related

CorelDRAW Graphics Suite 11 :: Exporting From Excel

Jun 1, 2011

We are using Coral Draw 11 and have to get a lot of our data from Excel. Currently we are copying and pasting the information in, but this is very time consuming. Is there a faster and simplier method?

View 4 Replies View Related

CorelDRAW Graphics Suite X5 :: Merge To New Document - Result Is Not Text?

Jul 19, 2012

I need to make a bunch of barcode tags for a client. I know CorelDraw isn't the best tool for this, but it's what I have and this is a one-time job.

To partially automate the process, I'm trying to use print merge to make the parts of the tags that aren't barcode, but I include the text that belongs in the barcode on the page. The print merge works correctly, I get what I expect. The next step would be to cut the barcode text, choose Insert Barcode, and then paste the barcode text into the barcode dialog.

Except, when trying to paste the text intended for the barcode I discovered that I was actually copying the <var1> field--not the text. I verified this by copying the "text" from the print merge document and then pasting back into the same document--what I got from the paste was not the expected text, but <var1>.

Since the barcode type I was using does not support the "<" character, it gave me an "invalid character" error.

My attempted solution was to publish to a PDF file and then import into a new document. This worked except for some reason CorelDraw makes a new layer named, inexplicably, "Layer 1" (there's a "Layer 1" by default, why make a second layer with the same name?) BUT when the import is done the new layer is NOT chosen in Object Manager, the original "Layer 1" is. Which means, when I go to copy the text and insert the barcode it ends up UNDER the other parts of the barcode tag which are on the NEW "Layer 1".

View 2 Replies View Related

Copyrights 2005-15, All rights reserved