Help - merge with one person and multiple entries

[Ryan D]

I'm trying to do a mailmerge from Excel. Below is a hypothetical spreadhseet
sample:

Bob --- 123 Any St. --- red car
Bob --- 123 Any St. --- blue car
Bob --- 123 Any St. --- yellow car
Jane --- 321 Any St. --- red car
Jane --- 321 Any St. --- green car
Sue --- 555 Any St. --- red car

The merged letters would appear as follows:

(letter 1)
Bob, of 123 Any St., has a red car, blue car, yellow car.
(letter 2)
Jane, of 321 Ant St., has a red car, green car.
(letter 3)
Sue, of 555 Any St., has a red car.

Rearranging the data is not feasible (over 1200 lines). Any suggestions on
how to do this?

 

[Peter Jamieson]

Word isn't designed for this, but see if the following article helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Peter Jamieson

 

[Ryan D]

Thanks. Is there any way to use that coding in an actual document as merge
fields? Or can Word/Excel simply not do what I am asking?

Thanks In Advance

 

[Peter Jamieson]

Is there any way to use that coding in an actual document as merge

fields?

Yes, but every time they show a pair of { }, you have to use ctrl-F9 to
enter them. Everything else is text, and you would obviously have to adapt
it for the specific column names in your data source and the output you want
to see.

There's another example at

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

in case that helps.

Peter Jamieson