Mail Merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JLD - 11 Sep 2006 21:10 GMT

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 to this Message

Peter Jamieson - 11 Sep 2006 21:34 GMT

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

>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
[quoted text clipped - 8 lines]
>
> Desperate for answers, JLD

Reply to this Message

Doug Robbins - Word MVP - 11 Sep 2006 22:06 GMT

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

Signature

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

Reply to this Message