Thread: Mail Merge Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Mail Merge Data

Word MVP Cindy Meister has merging instructions that may help you:

http://homepage.swissonline.ch/cindy...r/MergFram.htm

Under Special Merges, click Multiple items per condition.

JLD wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html