Mail Merge from Excel

JLD · Sep 11, 2006

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 · Sep 11, 2006

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 · Sep 11, 2006

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