Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

survey results printout with variable # of lines

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Igor - 18 Apr 2004 17:25 GMT
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.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.