Mail-Merge with Varying Data-Ranges

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

 

[Cindy M.]

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

The better place to pursue this question would be the word.mailmerge.fields
newsgroup, where you'll find more people who specialize in mail merge.

Your described approach can work, see this KB article:
HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000
http://support.microsoft.com?kbid=211303


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail