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
http://www.knowhow.com/Guides/Compou...poundMerge.htm
--
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
"JLD" wrote in message
...
I have a spreadsheet with one owner and address but with a list of multiple
vehicles and VIN numbers. I want to merge the data into Word with the
owner
name and address and then a list of the vehcilces and VIN numbers each
owner
has. I can creat a pivot table that displays the data correctly, but if I
then go to Word and mail merge the pivot table it places the vehicles on a
seperate sheet with the Owner name and address being blank.
How can I create this merge with the data from Excel?
Desperate for answers, JLD