[George Adams]

Hi, all. I have a fairly typical mail-merge job to do - I'm going to
create a paper directory of our church members, taking the data from an
ODBC database (MySQL). So it will look something like:

lastname, firstname
addressLine1
addressLine2
addressLine3
city, state ZIP
phone1
phone2
phone3
-- doublespace to start next record

I have a couple of basic questions:

1) How can I prevent a record from spanning multiple pages? i.e. how
can I tell Word that, if it can't fit an ENTIRE listing for a person in
the space left on the page, it should automatically go to the next page
and print the record there?

2) Is it possible to "collapse" the record if, say, addressLine2 and
addressLine3 aren't in the original MS-Access database? I don't want it
to print 2 blank lines - I want it to go straight from the lastname,
addressLine1 line to the city, state zip line.

I have Word 2000, XP, and 2003 to work with. If it's possible to
accomplish these goals on all 3 versions, that'd be nice! If not, I'll
take instructions for any version you can make to work.

Thanks to anyone who can help!