[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?

[Doug Robbins - Word MVP]

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Lisa" wrote in message
...
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?