Full Version: Merging Excel Files?
From: Melissa (OAKBROOK) [#1]
28 Aug 2006
To: ALL
Corel Draw and Excell files:
What's the fastest way to get this into the laser for raster & vector cut?
Our client needs 1200 seat donor ID plates. They will each have one, two or three lines on each.
She sent them in an excell file, each line in its own column.
How to merge them into a file that will engrave?
Job can't be split into all three-liners/all one-liners because it needs to be delivered in the order of the seats---orchestra first.....balcony last.....
EDITED: 28 Aug 2006 by DGL
From: Stunt Engraver (DGL) [#2]
28 Aug 2006
To: Melissa (OAKBROOK) [#1] 28 Aug 2006
Have you looked at Roy Brewer's "Print Merge" Flash tutorial?
There's a link at the top of our start page that will take there.
From: logojohn [#3]
28 Aug 2006
To: Melissa (OAKBROOK) [#1] 28 Aug 2006
If not, download open office, that will do it.
There are several macros that generous members have developed for manipulating the text(replace tabs puts the excel tabbed files on separate lines), duplicating multiple items on a plate(copy xy) and copying and pasting text directly in a coreldraw file(copy paste) before going to the printer. There is also one to remove unwanted characters or spaces at the beginning of each line if the find and replace option won't do it.
Check them out in the macros folder.
I was beginning to think I was the only one that had that type of tedious but lucarative jobs to do without spending all day on it.
.
From: Melissa (OAKBROOK) [#4]
28 Aug 2006
To: logojohn [#3] 28 Aug 2006
All day? We estimate it might take 2 months to get through this. Which is fine with the client, they expect it will take quite awhile to install them all on each correct seat.
I will check the macros, Thank you so much!
:D
From: Shaddy [#5]
28 Aug 2006
To: Melissa (OAKBROOK) [#1] 29 Aug 2006
Can you explain what the text lines will be?
First, liddle, last names? Title?
Do you need to have a serial number as well as the 3 text boxes?
Will the layout matter, as in, if there is only 1 text line, will it be in the same position as if there were 3? Or will the ones with 1 line need to be centered better?
What version of Corel are you using?
I might be able to help with a macro. I have one that can import up to 4 columns from Excel, but the layout might be a problem as mine expects the layout to already be in place and consistant.
Might not be too hard to customize into one centered text box though, just depends on your answers.
EDIT: PS, maybe a screen print of what a plate with one line and a plate with three look like. Make one up by hand in Corel then position them so you can see them all, then pres ALT-Prt Scrn (or ALT-Print Screen) on the keyboard. Then go to a graphics program and paste. Then crop and save and post.
Shaddy
EDITED: 28 Aug 2006 by SHADDY
From: Pedaler (ROYBREWER) [#6]
29 Aug 2006
To: Melissa (OAKBROOK) [#1] 29 Aug 2006
The skinny answer is save as a TAB delimited file and open that file in Corel's Print Merge Utility.
Our only concern is your
Depending on what you mean by that, often putting your variable into Paragraph text instead of Artistic text, will be an extremely simple solution.