TIP: Click on subject to list as thread! ANSI
echo: ms_word
to: JOHN HOWARD
from: ANANDA SIM
date: 1997-03-31 16:34:00
subject: Mail Merge

 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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.