JH> I use Word 97 to create problem sets for my
JH> students. I merge the data for each student with a
JH> prepared template. I am having one small problem,
JH> in that the only way that I can get the class
JH> designation to print, is to duplicate the it in
JH> every record. So it would look like it does below.
JH> Drafting Tom Jones 13 45 556 12 11
JH> Drafting Fred Marr 15 34 237 19 31
JH> Drafting Bill Harry 14 31 412 23 45
JH> Is there any way to have the "Drafting" entry only
JH> once in the Data Source?
The basic concept of mailmerge from a flat file is that you do
need to add all the "drafting" to each record. You could work
around by coding the long word to a shorter one and then find
a way to perform an if-then-else to expand it but that doesn't
cure a simple concept.
If you have access to MS Excel, you can use normal Copy, Paste
commands over many cells to save you typing into your datasource.
Additionally Excel 95 and 97 autofill as you type, which helps.
Ananda (my first message on a BBS and the first time I'm reading
this echo.)
---
---------------
* Origin: Melbourne PC User Group BBS (3:632/309)
|