[Lisa]

How do I create a mail-merge letter in which the number of cells in a given
column varies across recipients in my Excell spreadsheet?

In this case, I'm trying to create a mail-merge letter for customers
requesting information about the vehicles on an electronic toll tag account.
Some have only one vehicle, which is easy; but others have 20 or more. I need
this to be simple, so that reps. can enter the info on a spreadsheet quickly
and without having to think about it a lot. Hopefully they will be able to
enter the customers' contact info and acct number on one row, fill in as many
cells as they need in the vehicle column (say, through row 10 of that column)
and then start the next customer at the next row (row 11).

Closest I've been able to get is to have them fill all the other rows with
that same customer data, but of course that causes mail merge to create a
separate letter for each vehicle for the same customer. Any ideas?