Full Version: Merging Excel Files?
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.