Thread: text file merge
View Single Post
  #1  
Old 30-11-2007, 11:29
JeffG
Guest
 
Posts: n/a
Default text file merge

Hi,

We are using Draw X3 to create seating cards. We create the image and duplicate it for the number of guests. There is sample text for the guest name and table name. We then have to manually replace each name and table number.

Corel merge does not work for us for several reasons, the biggest being that we always need to edit names to fit by changing font size or line breaks.

I would like to have a macro/script that would automate the text replacement. I can create/convert the guest list in almost any format (Excel, tab, comma, etc).

I found this on the forum http://forum.oberonplace.com/showthr...ighlight=excel . This sounds like it might be just what I need if someone could tell me how it needs to be modifed so each Excel column replaces the placeholder.

I've done very little with VBA so detailed help would be greatly appreciated.

Thanks,
Jeff
Reply With Quote