Mail Merge from Excel

[JLD]

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

 

[Peter Jamieson]

That's curious - are the VIN numbers UK VIN numbers (or any other nation's
VIN numbers)? If so do you work for an authority concerned with VIN numbers?
If so, it seems odd that you would be "desparate for answers."..

Peter Jamieson

 

[Doug Robbins - Word MVP]

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

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

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


http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.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