PDA

View Full Version : Name Merge for 9/11 Memorial



Tim Bateson
01-01-2011, 12:46 AM
Senario: 90x17 inch black marble (cut into <= 24" sections). Now I need to merge into this all 3,000 names from 9/11.

So far, I have been able to cut and paste 65 names at a time (the # needed in each column). This process will work fine... if I want to spend the next 2 months doing it.

Any ideas/hints/lessons learned?

Randy Digby
01-01-2011, 1:33 AM
Tim, if the plates to be engraved are the same size and the text boxes for each name the same, if you gave me those dimensions and sent me the database/list of names I could load it into Engravelab and send you a pdf or other compatible file for each plate...I think. I'll be glad to give it a try if you want. Never tried this but it should work.

Tim Bateson
01-01-2011, 12:12 PM
Here is the list (had to break it up into 4 files to fit size restrictions here):

Scott Shepherd
01-01-2011, 12:31 PM
Am I missing something Tim, why not just use the mail merge on it?

Gary Hair
01-01-2011, 1:02 PM
The imposition layout would make this happen in about 5 minutes, or less. Search youtube for Roy Brewers tutorial and you'll be done in no time. If you can't find it using Roy's name then try searching for imposition layout.

Gary

Robert Walters
01-01-2011, 1:48 PM
Tim,

Roy Brewer's Print Merge videos:

http://www.youtube.com/user/EngravingConcepts1#p/u/4/BbZpC0JXXcs

http://www.youtube.com/user/EngravingConcepts1#p/u/11/bRCYZT7cRR8

Gary Hair
01-01-2011, 5:36 PM
Yep, that's the ones! Thanks for finding and linking them.

Gary

Tim Bateson
01-01-2011, 9:10 PM
Tried the Print Merge with < 1,000 names and after 30+ minutes it crashes Corel (X3)

Scott Shepherd
01-01-2011, 9:31 PM
Do 65 names at a time using that method. Still a heck of a lot easier than cutting and pasting. 65 in 15 seconds is better than nothing, plus it completes a column.

Randy Digby
01-01-2011, 10:14 PM
Tim, just checking to see if you got my PM...it's not showing up in my sent folder?

Josh Richard
01-02-2011, 12:14 PM
I have had success with Microsoft products. I made an Excel spreadsheet then used Microsoft word to make a mail merge document. I used a table to hold the text where I wanted it to be. I discovered how to control where the table top corner is then the size of each table box.
It worked great to simply put information on an item. We use it to put names on flash drives. When a student/students sells some, we put names in excel, then open and print from word. If you would like, tomorrow I can post documents

Robert Walters
01-03-2011, 5:39 PM
Tried the Print Merge with < 1,000 names and after 30+ minutes it crashes Corel (X3)

Tim,

You might try exporting the excel spreadsheet to CSV (or other text based) format, then try that with Corel.

Tim Bateson
01-05-2011, 12:29 AM
Still no luck. Not sure if it's X3 or my computer.

Mike Null
01-05-2011, 8:08 AM
Tim

Try converting the Excel to a text file in Notepad then import.

Joe De Medeiros
01-05-2011, 3:48 PM
Tim try this, it's in autocad format in 65 line columns, I have a tools to create autocad tables from excel or access files.