Mail Merge Data

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge from Excel 2
Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Grouping Names in Mail Merge 0
Page numbering with Merged Document and IF statements 1
Excel dup names not listed merge cells 1
Mail Merge - displaying a conditional number of decimals 5

Top