Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
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 "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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
Opening Word mail merge main doc also launches Excel? | Mailmerge | |||
Data frm excel to word using mail merge | Mailmerge | |||
Mail Merge: Excel (XP) fields scrambled during merge | Mailmerge | |||
Mail Merge does not accept formatted cell of Excel | Mailmerge |