I have done mail merges with labels, envelopes, letters. I understand some
of the concepts, but I am now stuck.
I have survey form results which have been converted into an xls file. The
demographic data is limited to <10 chars each field, but the comments field
can be anywhere from 10 chars to 1000. How can I get all of the records to
print out, one after the other, so that one record immediately follows the
other even if the comment field (which is the last field) is 1 line or 10?
I want consistently 2 blank lines between each record printed out.
I do understand, in basic ways, the "IF" statement, but how do I get this
to "loop"? When I do a label merge, for example, Word merge automatically
does this for me -- i.e., I only have to do a page of merge blocks and Word
seems to loop after each page until no more pages are needed. This works
fine for labels because you want them to each have the same vertical
dimensions. But I want each record to take up only as much vertical space
as it needs.
Help would be appreciated. Thanks.
Graham Mayor - 18 Apr 2004 17:33 GMT
You need to investigate directory/catalog merges which work the way you
require ie one record immediately follows the previous record.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
> I have done mail merges with labels, envelopes, letters. I
> understand some of the concepts, but I am now stuck.
[quoted text clipped - 16 lines]
>
> Help would be appreciated. Thanks.
Igor - 19 Apr 2004 00:12 GMT
Exactly! This saved me lots of time and frustration. And I thought it
might require some VB (which i don't know).
BTW, as is sometimes the case when I am told about a simple built-in
function in an application, I try to find the target again by searching
Help or other documentation. Whether it is me or a lack of good design in
Word2000, I could not find my way to "catalog merge" by simply looking
under "merge" and bouncing around from the search results in Help. Only
after you gave me the term "catalog" was I able to find the references by
searching "catalog merge"..
Again, many thanks.
>You need to investigate directory/catalog merges which work the way you
>require ie one record immediately follows the previous record.
>
>> I have done mail merges with labels, envelopes, letters. I
>> understand some of the concepts, but I am now stuck.